Interested to Buy Any Domain ? << Click Here >> for more details...
how can u avoid duplicate rows in flat file?
- 4 Answers
- 10878 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ramanaiah
without using sorter,and aggregrator transformations.we can
useing dynamic lookup to avoid duplicate rows.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is the sequence generator transformation in informatica?
What is a surrogate key?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
list out all the transformations which use cache?
what is the hint? how to use it to reduce the query processing in program?
How to call shell scripts from informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is repository manager?
write a query to retrieve the latest records from the table sorted by version(scd)
What is a pre-defined event and user-defined event?
Explain about cumulative Sum or moving sum?
have u done any performance tuning? how u ll do?
What is standalone command task?
What is union transformation?
