How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
Answer Posted / chandu
we can achieve this by using first value or last value in lkp properties.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
Informatica Checkpoints
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
Which files are created during the session rums by informatics server?
Explain your project of banking domian.
How many input parameters can exist in an unconnected lookup?
What is substr in informatica?
What are the restrictions of union transformation?
What is joiner transformation?
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.
What do you mean by enterprise data warehousing?
What is the meaning of up gradation of repository?
Mention few advantages of router transformation over filter transformation.
Explain sessions?
What is the difference between router and filter?