Answer Posted / rakesh
since Union Transformation is derived from CUSTOM Transformation which is active.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
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.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain the use of aggregator cache file?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is different between the data warehouse and data mart?
Briefly explain the aggregator transformation?
What are the databases that informatica can connect to windows?
How to partition the Session?
What is the difference between a connected look up and unconnected lookup?
What are the informatica performance improvement tips
What is the sequence generator transformation in informatica?
What are some examples of informatica etl programs?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How does a rank transform differ from aggregator transform functions max and min?