Interested to Buy Any Domain ? << Click Here >> for more details...
how can u avoid duplicate rows in flat file?
- 4 Answers
- 10756 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil
In a sorter transformation select distinct option to avoid
duplicates in a flat file
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / ramanaiah
without using sorter,and aggregrator transformations.we can
useing dynamic lookup to avoid duplicate rows.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sbvp
i also faced this question . i said that i am using sorter
and agg group by options. but they ask me again with out
using sorter and agg how can u eliminate the duplicates? so
, plz give me a answer for that
| Is This Answer Correct ? | 0 Yes | 0 No |
What is source qualifier transformation in informatica?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Which is costliest transformation? costly means occupying more memory?
Target is zero file and how can you send the email?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
what is the drillup & drill down?and use of the drill up and drill down?
What are the popular informatica products?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What is meant by LDAP users?
What is junk dimention?
Teradata 
