what is the gap analysis?
Answer / slim
its the difference between what is needed and what is
available...
| Is This Answer Correct ? | 4 Yes | 0 No |
Briefly explain the aggregator transformation?
What are Business Components in Informatica?
Differentiate between a repository server and a powerhouse?
How big was your fact table
h0w many versions have been developed of onformatica so far?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
How to fix the etl bugs..Tell me the process?
Why sorter is an active transformation?
what is correlated query?