Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records in a flat file source?
- 2 Answers
- 8697 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
conncet the flat file to sorter transformation and select
distinct option.
| Is This Answer Correct ? | 17 Yes | 6 No |
Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.
| Is This Answer Correct ? | 0 Yes | 0 No |
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
What is confirmed fact in dataware housing?
What are the designer tools for creating transformations?
how to design mapping half of source table records into one target and remaining half into another target
Enlist the differences between database and data warehouse.
What are the phases in SDLC?
Can u generate reports in Informatica?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
Teradata 
