How to eliminate duplicates from flat file..what is the
procedure
Answer Posted / muddam
Select all ports as group by then Create one o/p o_count in
aggregater(o_count>1). Before this you wolud have taken one
sorter trans for sorted data.
It will work out.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a sequence generator transformation?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
whats the logic to load the lower level of granularity of data to fact table.
is it possible to index the data in cache of lkp transformation ?
Name the different lookup cache(s)?
What are ETL Tools?
Is there any way to read the ms excel datas directly into informatica?
What are active transformations.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Can we create two repositories on same database instance in oracle?
How do you load first and last records into target table?
How can we delete duplicate rows from flat files?
What is different between the data warehouse and data mart?
What are the components of the workflow manager?
What is domain in terms of informatica?