Interested to Buy Any Domain ? << Click Here >> for more details...
how will you remove the duplicate records from flat file
without using sorter?
- 7 Answers
- 18730 Views
- I also Faced
- E-Mail Answers
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
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
What is Cognos script editor?
Explain Dataware house architecture .how data flow from intial to end?
Write the unconnected lookup syntax and how to return more than one column.
Explain joiner transformation in informatica
Different sorts of metadata that stores in the storage facility?
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
How do you take back up of repository?
What is data transformation manager process?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Enlist the differences between database and data warehouse.
What is a filter transformation and why it is an active one?
What is incremental aggregation?
What does role playing dimension mean?
What is a surrogate key?
