how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / sathish
use aggregater T/R after source qualifier select all ports in group by clause it will removes the duplicates
|Is This Answer Correct ?||5 Yes||2 No|
Mention few advantages of router transformation over filter transformation.
What are the modules in Power Center
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Define enterprise data warehousing?
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?
What is meant by active and passive transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- email@example.com
Enlist the tasks for which source qualifier transformation is used.
4 yrs etl devloper roles and responsibilities?any body give solutions
In informatica workflow manager, how many repositories can be created?
What could be the possible resons of locks by user?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
How to join three sources using joiner? Explain though mapping flow.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
According to his methodology what all you need before you build a datawarehouse