how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / krishnakanthch
We can use the option 'SELECT DISTINCT' in the source
qualifier.
Anybody please tell me whether this works or not.
Is This Answer Correct ? | 5 Yes | 23 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
What is a sequence generator transformation?
Could you explain what is enterprise data warehouse?
What is an active transformation?
Explain sessions?
Why is sorter an active transformation?
How identifying bottlenecks in various components of informatica and resolving them?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
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
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Under which circumstances, informatica server creates reject files?
What is a shortcut and copy in Informatica and how two are different with each other?
What is informatica powercenter repository?
Explain the scenario which compels informatica server to reject files?
How you know when to use a static cache and dynamic cache in lookup transformation?