In update strategy target table or flat file which gives
more performance ? why?
Answer Posted / nishtha
Can someone pls give correct answer for this question?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain Dataware house architecture .how data flow from intial to end?
Write the program through which the records can be updated?
What are the differences between a connected lookup and unconnected lookup?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain in detail about scd type 1 through mapping.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain the pipeline partition with real time example?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain sessions?
Explain informatica architecture - version 8 / 9
What is dynamic cache?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?