Skip to main content

Top 100 Informatica Interview Questions


I have attended Informatica interview last week in wipro and couple of other companies, Question below I faced in those companies.


1. What are the main issues while working with flat files as source and as targets ?

2. Explain about Informatica server process that how it works relates to mapping variables?

3. write a query to retrieve the latest records from the table sorted by version(scd)

4. How do you handle two sessions in Informatica

5. which one is better performance wise joiner or look up

6. How to partition the Session?

7. How many types of sessions are there in informatica.please explain them.

8. Explain the pipeline partition with real time example?

9. Explain about cumulative Sum or moving sum?

10. CONVERT MULTIPLE ROWS TO SINGLE ROW (MULTIPLE COLUMNS) IN INFORMATICA

11. DEPLOYMENT GROUPS IN INFORMATICA

12. LOAD LAST N RECORDS OF FILE INTO TARGET TABLE - INFORMATICA

13. LOAD ALTERNATIVE RECORDS / ROWS INTO MULTIPLE TARGETS - INFORMATICA

14. SCHEDULING OPTIONS OF INFORMATICA ETL TOOL WORKFLOWS / JOBS

15. HOW TO CREATE USER DEFINED FUNCTION (UDF) IN INFORMATICA

16. PUSHDOWN OPTIMIZATION $PUSHDOWNCONFIG PARAMETER - INFORMATICA

17. PUSHDOWN OPTIMIZATION AND TYPES IN INFORMATICA

18. HOW TO LOAD ROWS INTO FACT TABLE IN DATA WAREHOUSE

19. PMCMD COMMAND USAGE IN INFORMATICA

20. DIFFERENCE BETWEEN STOP AND ABORT IN INFORMATICA

21. GENERATE DATE / TIME DIMENSION IN INFORMATICA

22. INFORMATICA ARCHITECTURE TUTORIAL - VERSION 8 / 9

23. TUNING LOOKUP TRANSFORMATION - INFORMATICA

24. LOOKUP TRANSFORMATION IS ACTIVE - INFORMATICA

25. CREATING LOOKUP TRANSFORMATION - INFORMATICA

26. CONNECTED AND UNCONNECTED LOOKUP TRANSFORMATION - INFORAMTICA

27. LOOKUP TRANSFORMATION SOURCE TYPES IN INFORMATICA

28. LOOKUP TRANSFORMATION IN INFORMATICA

29. TARGET UPDATE OVERRIDE - INFORMATICA

30. UPDATE STRATEGY TRANSFORMATION IN INFORMATICA

31. SQL QUERY OVERWRITE IN SOURCE QUALIFIER - INFORMATICA

32. How to generate sequence numbers without using the sequence generator transformation?

33. REUSABLE VS NON REUSABLE & PROPERTIES OF SEQUENCE GENERATOR TRANSFORMATION

34. How to load the data from a flat file into the target where the source flat file name changes daily?

35. DIRECT AND INDIRECT FLAT FILE LOADING (SOURCE FILE TYPE) - INFORMATICA

36. I have a flat file, want to reverse the contents of the flat file

37. Which means the first record should come as last record and last record should come as first record and load into the target file?

38. MAPPING VARIABLE USAGE EXAMPLE IN INFORMATICA

39. TRANSACTION CONTROL TRANSFORMATION IN INFORMATICA

40. How to load the name of the current processing flat file along with the data into the target using informatica mapping?

41. JOINER TRANSFORMATION IN INFORMATICA

42. How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

43. RANK TRANSFORMATION IN INFORMATICA

44. How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

45. CONSTRAINT BASED LOADING IN INFORMATICA

46. SQL TRANSFORMATION IN SCRIPT MODE EXAMPLES - INFORMATICA

47. How to generate or load values in to the target table based on a column value using informatica etl tool.

48. DYNAMIC TARGET FLAT FILE NAME GENERATION IN INFORMATICA

49. INCREMENTAL AGGREGATION IN INFORMATICA

50. WHAT IS INFORMATICA POWERCENTER

51. What is the need of an ETL tool

52. INFORMATICA PERFORMANCE IMPROVEMENT TIPS

53. What is polling?

54. In which circumstances, informatica server creates Reject files?

55. What are the data movement modes in informatica?

56. Define mapping and session?

57. Can u generate reports in Informatica?

58. What is metadata reporter?

59. What is the default source option for update strategy transformation?

60. What is Data driven?

61. What are the tasks that source qualifier perform?

62. What is the default join that source qualifier provides?

63. What are the basic requirements to join two sources in a source qualifier transformation using default join?

64. What are the differences between joiner transformation and source qualifier transformation?

65. What are the limitations of joiner transformation?

66. What are the settings that you use to configure the joiner transformation?

67. What are the join types in joiner transformation?

68. What are the joiner caches?

69. What is the look up transformation?

70. Why use the lookup transformation?

71. What are the types of lookup transformation?

72. What is meant by lookup caches?

73. What are the types of lookup caches?

74. Which transformation should we use to normalise the COBOL and relational sources?

75. In which transformation you cannot drag ports into it?

76. How the informatica server sorts the string values in Rank transformation?

77. What are the rank caches?

78. What is the Rank index port in Rank transformation?

79. What is the Router transformation?

80. What are the types of groups in Router transformation?

81. What are the types of data that passes between informatica server and stored procedure

82. What is the status code in stored procedure transformation?

83. What is the target load order?

84. While importing the relational source definition from the database, what are the metadata of source that will be imported?

85. How many ways a relational source definition can be updated and what are they?

86. To import the flat file definition into the designer where should the flat file be placed?

87. To provide support for Mainframes source data, which files are used as a source definitions?

88. Which transformation is needed while using the Cobol sources as source definitions?

89. How to create or import flat file definition in to the warehouse designer?

90. What is a mapplet?

91. What is a transformation?

92. What are the designer tools for creating transformations?

93. What are active and passive transformations?

94. What are connected or unconnected transformations?

95. How many ways are there to create ports?

96. What are the reusable transformations?

97. What are the methods for creating reusable transformations?

98. What are the unsupported repository objects for a mapplet?

99. What are the mapping parameters and mapping variables?

100. Can we use the mapping parameters or variables created in one mapping into another mapping?

101. Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

102. How can we improve session performance in aggregator transformation?

103. What is aggregate cache in aggregator transformation?

104. What is an active transformation?

105. What is a passive transformation?

106. What is a connected transformation?

107. What is an unconnected transformation?

108. What are multi-group transformations?

109. List out all the transformations which use cache?

110. What is blocking transformation?

111. How do you promote a non-reusable transformation to reusable transformation?

112. How to create a non-reusable instance of reusable transformations?

113. Which transformation can be created only as reusable transformation but not as non-reusable transformation?

114. As union transformation gives UNION ALL output, how you will get the UNION output?

115. What are the guidelines to be followed while using union transformation?

116. Why union transformation is an active transformation?

117. What is a transaction control transformation?

118. What is the commit type if you have a transaction control transformation in the mapping?

119. What are the different transaction levels available in transaction control transformation?

120. What is a sorter transformation?

121. Why sorter is an active transformation?

122. How to improve the performance of a session using sorter transformation?

123. How to generate sequence numbers using expression transformation?

124. Design a mapping to load the cumulative sum of salaries of employees into target table?

125. Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

126. Design a mapping to load a target table with the following values from the above source?

127. What is Data Caches size?

128. What is Index Caches size?

129. Difference between Data and Index Caches?

130. Difference between Dynamic and Static Lookup Cache?


Contributor 


P Ganesh

Comments

  1. Can you please post answer as well

    ReplyDelete
    Replies
    1. Click on the questions you will find answers, some of the answers I posted in comment itself.

      Thanks
      Kashif M

      Delete
  2. I am eagerly waiting your above questions answers because I feel these questions are very very important .

    ReplyDelete
    Replies
    1. Niranjan - Answers has been posted for informatica interview questions below

      Delete
  3. why is ganesh not posting answers

    ReplyDelete
  4. Ok, I will post the answer soon. I started preparing it.

    ReplyDelete
    Replies
    1. Kashif, Can you please post the answers. Thanks in advance

      Delete
  5. Kindly post answers as soon as possibly.

    ReplyDelete
  6. Can you please post the answers

    ReplyDelete
  7. Please post answers.. if anyone got answers for above questions please send to my email id. my id : bojanapatipadma@gmail.com

    -Padma

    ReplyDelete
    Replies
    1. Hi Padma gaaru...i am rammohan...if u have the answers for the above questions please forward the same to my email id once...ummadiramu@gmail.com

      Delete
    2. hi padmagaru if u wil get answers for above questions plz forward to mail id......amarnath.reddy678@gmail.com

      Delete
  8. If any one get the answers please send me to mail ID Chandrasekhar.uppara@gmail.com

    ReplyDelete
  9. Hi Mates,

    I have started posting answer for above questions, will be completing by next weekend.

    Kashif M

    ReplyDelete
    Replies
    1. Hi Kashif

      Couldn't find answers in the blog. Can you please mail them at bhatnagar.prachi845@gmail.com

      Thanks

      Delete
  10. hi,
    if you guys find answers please mail to me babi.tillu@gmail.com

    Thank in advance,

    ReplyDelete
  11. hi if anyone got answers above qutions please send me my mailid:sravanreks@gmail.com

    ReplyDelete
  12. hi Kashif,
    Can you please post the answer.

    ReplyDelete
  13. This comment has been removed by the author.

    ReplyDelete
  14. hi kashif,

    Pls post the answer or mail me @ nagulan0389@gmail.com

    ReplyDelete
    Replies
    1. Hi Naga,

      Informatica Interview question has been posted for your reference.

      Delete
  15. heloo
    These are vey important questions.Please send me the answer
    -punyaprashanta@gmail.com

    ReplyDelete
    Replies
    1. I have send you the informatica interview question to your email.

      Delete
  16. Thanks kashif..you are doing great job

    ReplyDelete
  17. hi kashif,
    please send me the answers my mailid : sravanreks@gmail.com

    ReplyDelete
  18. Hi Kashif,

    Can you send me the answers to my email please?
    my email is damnjc@gmail.com

    Thanks.

    ReplyDelete
  19. please also send me the answers... to forgetalways0@gmail.com

    ReplyDelete
  20. please send the answers to eml.ajay@gmail.com

    ReplyDelete
  21. 125. Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
    SQ->Expression->target
    Expression -> V_count=V_count+1 (variable port)
    V_salary=IIF (V_count=1, NULL,V_prev_salary) (variable port)
    V_prev_salary=salary (variable port)
    O_prev_salary=V_salary (output port)

    ReplyDelete
    Replies
    1. hi,
      I have tried the above expression(s) and getting only row numbers not the previous row salary.

      Delete
  22. 124. Design a mapping to load the cumulative sum of salaries of employees into target table?
    SQ-> Expression->target
    Expression transformation-> create a variable port V_cum_sal= V_cum_sal+salary
    Create an output port O_cum_sal = V_cum_sal

    ReplyDelete
  23. 118. What is the commit type if you have a transaction control transformation in the mapping?
    TC_COMMIT_BEFORE
    TC_COMMIT_AFTER
    119. What are the different transaction levels available in transaction control transformation?

    TC_CONTINUE_TRANSACTION
    TC_COMMIT_BEFORE
    TC_COMMIT_AFTER
    TC_ROLLBACK_BEFORE
    TC_ROLLBACK_AFTER
    120. What is a sorter transformation?
    Sorter transformation is an active and connected transformation which is used to sort the data in ascending or descending order.
    121. Why sorter is an active transformation?
    Since it has distinct option in its properties which filters duplicate records.
    122. How to improve the performance of a session using sorter transformation?
    Sorter transformation can be placed before the transformations which have sorted input port in it, to improve the session performs.

    123. How to generate sequence numbers using expression transformation?
    We can do with the expression transformation, create a variable port and increment it by 1. Then assign the variable port to an output port. In the expression transformation, the ports are:
    V_count=V_count+1
    O_count=V_count

    ReplyDelete
  24. 113. Which transformation can be created only as reusable transformation but not as non- reusable transformation?
    External Stored Procedure




    114. As union transformation gives UNION ALL output, how you will get the UNION output?
    1. Pass the data from union transformation to sorter.
    2. Enable distinct option in sorter transformation which eliminates the duplicate data.
    3. Then connect it to the target transformation.

    ReplyDelete
  25. . What are the mapping parameters and mapping variables?
    Mapping parameter is static value that can be defined in the session level.It maintains the same value throughout the session.
    Mapping variable is dynamic throughout the session. The Informatica server saves the value of mapping variable to the repository at the end of session run and uses that value next time you run the session.



    100. Can we use the mapping parameters or variables created in one mapping into another mapping?
    NO, Mapping parameters or variables that is created in one mapping or mapplet cannot be used in other mapping but can be used in different transformations of the same mapping or mapplet.


    101. Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
    Yes. Because reusable transformation is not defined for a particular mapping or mapplet.


    102. How can we improve session performance in aggregator transformation?
    By using sorted input port in aggregator transformation improves the session performance. It means that the data that pass to the aggregator should be sorted before by using sorter transformation.


    103. What is aggregate cache in aggregator transformation?
    The aggregator transformation use data caches and index caches which stores data until it completes aggregate calculations.


    104. What is an active transformation?
    Active transformation is which change the no.of rows that pass through it.
    (ie. No. of i/p rows =, <,> no. of o/p rows)


    105. What is a passive transformation?
    Passive transformation is which cannot change the no.of rows that pass through it.
    (ie. No.of i/p rows = no. of o/p rows)


    106. What is a connected transformation?
    Connected transformation is connected through pipeline to other transformations.


    107. What is an unconnected transformation?
    Unconnected transformations is not connected to other transformations can be called through other transformation by some key code.


    108. What are multi-group transformations?
    The transformations have multiple groups that is, one group of input ports and one group of output ports are multi-group transformations. You do not have to specify the group with which to associate a rule.
    Eg: Router transformation, Union transformation


    109. List out all the transformations which use cache?
    Lookup, Aggregator, Rank, joiner


    110. What is blocking transformation?
    When the integration service processes an unsorted joiner transformation, it reads all master rows before it reads the detail rows. To ensure it reads all master rows before the detail rows, the integration service blocks all the details source while it caches rows from the master source. As it blocks the detail source, the unsorted joiner is called a blocking transformation.


    111. How do you promote a non-reusable transformation to reusable transformation?
    By enabling make reusable option by editing the transformations.


    112. How to create a non-reusable instance of reusable transformations?
    We can drag the transformation from the transformation developer rather from creating new one. Since the reusable transformations are saved only in the transformation developer.


    113. Which transformation can be created only as reusable transformation but not as non- reusable transformation?
    External Stored Procedure



    114. As union transformation gives UNION ALL output, how you will get the UNION output?
    1. Pass the data from union transformation to sorter.
    2. Enable distinct option in sorter transformation which eliminates the duplicate data.
    3. Then connect it to the target transformation

    ReplyDelete
  26. 69. Why use the lookup transformation?
    Lookup transformation mainly used
    • To get related values
    • To update SCD’s
    • To perform calculations.

    71. What are the types of lookup transformation?
    Connected lookup and unconnected lookup

    72. What is meant by lookup caches?

    The Informatica server builds a cache in memory when it processes the first row of a data in a cached look up transformation. It allocates memory for the cache based on the amount you configure in the transformation or session properties. The Informatica server stores condition values in the index cache and output values in the data cache.
    The result of the Lookup query and processing is the same, whether or not you cache the lookup source. However, using a lookup cache can increase session performance. You can optimize performance by caching the lookup source when the source is large.
    If the lookup does not change between sessions, you can configure the transformation to use a persistent lookup cache. When you run the session, the Integration Service rebuilds the persistent cache if any cache file is missing or invalid.
    The Integration Service creates the following caches for the Lookup transformation:

    Data cache. For a connected Lookup transformation, stores data for the connected output ports, not including ports used in the lookup condition. For an unconnected Lookup transformation, stores data from the return port.

    Index cache. Stores data for the columns used in the lookup condition.

    73. What are the types of lookup caches?
    1. Static cache
    2. Dynamic cache
    3. Persistence cache
    4. Recache
    5. Shared cache

    74. Which transformation should we use to normalize the COBOL and relational sources?
    Normalizer Transformation.

    75. In which transformation you cannot drag ports into it?
    Sequence Generator

    76. How the Informatica server sorts the string values in Rank transformation?
    When the Informatica server runs in the ASCII data movement mode it sorts session data using Binary sort order. If you configure the session to use a binary sort order, the Informatica server calculates the binary value of each string and returns the specified number of rows with the highest binary values for the string.

    77. What are the rank caches?
    Rank index cache
    Rank data cache

    78. What is the Rank index port in Rank transformation?
    Rank index port in rank transformation will give the ranking position for each record in a group. For example, if you create a Rank transformation that ranks the top 5 salespersons for each quarter, the rank index numbers the salespeople from 1 to 5.

    79. What is the Router transformation?
    • Router transformation is the active and connected transformation which is used for multiple filter conditions.
    • Router transformation is faster than multiple filter transformation since it fetches data once whereas filter transformation fetch each time for the conditions.
    • Router transformation has the default group in it where it holds the data which does not meet the conditions and we can pass that data to different target.


    80. What are the types of groups in Router transformation?
    User defined groups and default group.


    81. What are the types of data that passes between Informatica server and stored procedure?
    • Input/output parameters
    • Return Values
    • Status code.


    ReplyDelete

  27. 82. What is the status code in stored procedure transformation?
    Status code provides error handling for the Informatica server during the session.The stored procedure issues a status code that notifies whether or not stored procedure completed sucessfully. This value cannot be seen by the user. It only used by the Informatica server to determine whether to continue running the session or stop.

    83. What is the target load order?
    The target load order is the process where Informatica server loads the data into the target while using multiple sources into multiple targets.

    84. While importing the relational source definition from the database, what are the metadata of source that will be imported?
    • Source name
    • Database location
    • Column names
    • Data types
    • Key constraints

    85. How many ways a relational source definition can be updated and what are they?
    We can update the source definition by
    1. Editing the source.
    2. Reimporting the source.


    86. To import the flat file definition into the designer where should the flat file be placed?
    By default the file will be placed in ‘Informatica\server\infashared\srcfiles\’


    87. To provide support for Mainframes source data, which files are used as a source definitions?
    COBOL files


    88. Which transformation is needed while using the COBOL sources as source definitions?
    Normalizer Transformation

    ReplyDelete
  28. Dears,

    I have given answer for almost all question.

    Thanks
    Kashif M

    ReplyDelete
    Replies
    1. Hi Kashif..can you please send me the answers to my email id please
      ummadiramu@gmail.com

      Delete
  29. Hi Kashif,

    Can you please send me the answers on this email id - jaydeep4mgcet@gmail.com ?

    Thanks,
    Jaydeep Patel

    ReplyDelete
  30. Please send to my email
    SR999@outlook.com

    ReplyDelete
  31. Please send answers to my mail id: rooparv@gmail.com

    Thankyou

    ReplyDelete
  32. Could you please forward answers to my email.
    eswar13579@gmail.com

    Thanks in advance.

    ReplyDelete
  33. Hi Kashif,

    Could you please send answeres to my maild id archanaisthebest2000@gmail.com

    ReplyDelete
  34. Hi could you pls send answers to my mail id sravanreks@gmail.com

    ReplyDelete
  35. hi this is laxman ur questions are very good could you plz send me answers to my mail id laxman.varma@gmail.com

    ReplyDelete
    Replies
    1. Click on the questions Naidu. You will get the answers, else see on comments box you will find all the informatica questions related answers.

      Delete
  36. Hello Kashif,

    You are really amazing . Can you please do me a favor by sending the answers to my personal email dev.s.manhas@gmail.com

    Thanks in advance.

    ReplyDelete
  37. hello kashif,

    hi this is nagesh,can u please send me answers to my mail
    chinnioracle451@gmail.com

    thanks....

    ReplyDelete
  38. Can anyone please send me the answers to my mail id :srinivasn80@gmail.com

    ReplyDelete
  39. Hi,

    Please send the questions and answers to nagarajmeena@gmail.com ASAP...

    ReplyDelete
  40. can you please send answers to achyuthram.8@gmail.com

    ReplyDelete
  41. Hi,

    Can you please send answers to shilpa.429@gmail.com

    Thanks

    ReplyDelete
  42. hello kashif m

    please send me the questioms and answers

    ReplyDelete
    Replies
    1. click on the every question u will get answers

      Delete
  43. Hi Kashif-

    Would you please send me the questions and answers to j3mann@gmail.com?

    Thanks!

    ReplyDelete
  44. Hi Kashif,

    Can you please send the answers on saya124@gmail.com?

    Thanks!!

    ReplyDelete
  45. Can u pls send the answer to fly2prabucse@gmail.com

    Thanks.....

    ReplyDelete
  46. Could you please send the answers to amarindurthi@gmail.com

    ReplyDelete
  47. please send answers to viswanath.mantha@gmail.com

    ReplyDelete
  48. Great Information admin thanks For Your Blog and Any body wants learn

    Informatica through Online for Details Please go through the Link



    Online Informatica Training by Vast Experienced and dedicated professional

    trainers


    This Will Helps you alot. They Will provide Question and Answers for Intreview

    ReplyDelete
  49. Not able to copy and Paste the qs. and answers
    for offline document

    ReplyDelete
  50. Kashif, great work my friend. !!!!

    ReplyDelete
  51. Kashif, great work my friend. !!!!

    ReplyDelete
  52. Hi Kashif,

    Could you please forward the answers to my email-id: priyanshi.jaiswal22@gmail.com

    ReplyDelete
  53. hi Kashif,
    Can you please forward answers to email: susheel99@gmail.com

    Thanks.

    ReplyDelete
  54. Hi kashif ,

    can u pls forward above quests ans to rashmirai15@gmail.com

    Thanks,
    Rashmi

    ReplyDelete
    Replies
    1. I have send you email Rashmi on informatica interview questions.

      Delete
  55. Dears,

    Thanks to all my readers.

    I have recently published Informatica scenario based questions.


    http://mkashu.blogspot.in/2014/06/informatica-scenario-based-interview.html

    ReplyDelete
  56. really appreciate for your information.a free demo on informatica online training with study material.
    INFORMATICA Online Course

    ReplyDelete
  57. Please post the answers to my mail id ,, plzzzzzzzzzzzz

    buvana.sbagur@gmail.com

    ReplyDelete
  58. Thanks a lot kashif.....could you please inbox me the answers on vishal.saini21@Gmail.com

    ReplyDelete
  59. plse send ans to my mail sasikanth461@gmail.com

    thanks in advance

    ReplyDelete
  60. any1 plz send answers to my mail

    sudhakarreddygajjala@gmail.com

    TIA

    ReplyDelete
  61. This comment has been removed by the author.

    ReplyDelete
  62. Hi,

    can someone please send answers to my mail id which is mentioned below.

    srisuvikri@gmail.com

    ReplyDelete
  63. Hi Kashif
    Thank you very much for the Q&A. Its very helpful
    Can you forward all Q&A to my mail id: anu.bangalore@gmail.com

    ReplyDelete
  64. Hi kashif sir,
    can u forward answers to my mail
    venkata.balaji1@gmail.com

    ReplyDelete
  65. Hi Kashif, very useful site. Best site to learn more about informatica. Can u please forward all the Q & A to mail: kanithi02@gmail.com. Tq.

    ReplyDelete
  66. Hi kashif sir, Plz forward all the Q & A to mail: venkat6d@gmail.com
    Thanks in advance

    ReplyDelete
  67. Thank you for the Q&A, kashif. Could you send the Q&A to my email please? my email is tomsaaa@gmail.com

    ReplyDelete
  68. Thanks for Sharing such a Wonderful Information....

    Learn informatica through Online for Details Please go through the Link
    http://www.iqonlinetraining.com/informatica-online-training/

    ReplyDelete
  69. Hi Kashif

    Could you please send answers to dsureshv@gmail.com

    Thank you verymuch for your help

    ReplyDelete
  70. Hi KASHIF ....., please send the answers to my mail id purumrajesh@live.com

    ReplyDelete

  71. I was totally amazed when i saw this website Best Informatica Online Training first time i thought this is what i am looking for from a long time i am very thankful to you for helping not only me but to all those guys who are new to this IT SECTOR and who wants to make a career in this sector.

    ReplyDelete
  72. Hi guys,
    Could any one please send the answers to kiranangara7@gmail.com

    ReplyDelete
  73. Hi guys,
    Could any one let me know how better is informatica for Non-IT's as if m not from s/w feild but wanted to make career in informatica

    ReplyDelete
  74. also can any one say what tools are needed for informatica

    ReplyDelete
  75. It was so nice article and useful to Informatica learners. we also provide Informatica Course online training our Cubtraining is leader in providing Software Training

    ReplyDelete
  76. Hi

    Could you please send the answers of the above question to my mail id: sunil.patnaik0@gmail.com

    Thanks

    ReplyDelete
  77. Thank you for sharing your thoughts. I really appreciate your efforts
    and I will be waiting for your next write ups thanks once again.
    Informatica training | Microsoft Dynamics CRM Training

    ReplyDelete
  78. Nice article.Thank you for sharing this.We are providing Informatica Online training.INFORMATICA Online Training

    ReplyDelete
  79. Thanks you so much sharing informatica interview question . it is very useful for my interview process time Java Training Chennai

    ReplyDelete
  80. Good sites because it is very useful question to sharing Java Training in Chennai

    ReplyDelete
  81. Thanks For Sharing This is Very useful Information
    Hamsini Technologies is One of the Best Institute to Provide Online IT Trainings.
    We have Real-time Industry experts to provide Online,Classroom & corporate Trainings around the world.

    Contact us for more details .
    Informatica Online training

    ReplyDelete

  82. wow....Thanks for sharing this great source full of Data Stagerelated posts.realy great work onece again thanks me and smartmindonlinetraining.

    ReplyDelete
  83. if learned in this site.what are the tools using in sql server environment and in warehousing have the solution thank ..msbi training In Chennai

    ReplyDelete
  84. Its really helpful for me to understand. Thanks.If anyone wants to Learn visit this page sybase training In Chennai

    ReplyDelete
  85. HI All,
    Plz mail the answers to baskarvenu61@gmail.com if any got the answers.
    Thanks

    ReplyDelete
  86. Hi Kashif/all
    who ever reading this

    Please email me the answers to ghouse.dwh.info@gmail.com

    Thanks
    Ghouse

    ReplyDelete
  87. Hi all

    Please email me the answers to ghouse.dwh.info@gmail.com

    ReplyDelete
  88. Hi kashif,
    please send me all answers to valliarif@gmail.com

    ReplyDelete
  89. CAN U PLEASE POST THE ANSWERS

    OR EMAIL ME THE ANSWERS IN MY EMIAL ID:-ppchavan11@gmail.com

    ReplyDelete
  90. Hi Kashif,

    Could you please mail the above informatica questions and answers for below mail id its very important
    hemaraju63@gmail.com

    ReplyDelete
  91. Hi all,

    Please send me answers to sraviap@gmail.com.

    Thanks in Advance

    ReplyDelete
  92. Hi all,

    Please send me the answers to sraviap@gmail.com

    Thanks in Advance

    ReplyDelete
  93. Hi All,

    Please email me the answersto hemaraju63@gmail.com. It will be very helpful .

    ReplyDelete
  94. Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.
    Informatica Training In Chennai
    Hadoop Training In Chennai
    Oracle Training In Chennai
    SAS Training In Chennai

    ReplyDelete
  95. Hi Kashif,

    Good Day !

    Please send me the all answers to my email id : muralimohanarao2@gmail.com

    Thanks & Regards,
    Murali M

    ReplyDelete
  96. please send me above answers to my mail.com sree.kotoju@gmail.com

    Regards
    sreekanth

    ReplyDelete
  97. Hi Kashif,

    Can u please send answera to my emaid id sehra.alisha@gmail.com.

    It will be a great help!! Hava a nice day

    Thanks,
    Alisha

    ReplyDelete
  98. Hi Kashif,

    Can u please send all the answers to my maid id sehra.alisha@gmail.com
    It will be a great help!!

    Have a good day.

    Thanks
    Alisha

    ReplyDelete
  99. informatica interview questions nic eposts thanku for sharing..

    informatica training

    ReplyDelete
  100. top 100 informatica interview questions..
    informatica training

    ReplyDelete
  101. Replies
    1. Answers has been posted already Chinmaye.

      Delete
  102. You welcome Srinivas. I hope you received all the answers on informatica interview questions

    ReplyDelete
  103. Thanks for sharing 100 informatica interview questions. I am looking for more informatica interview questions.

    ReplyDelete

Post a Comment

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope