How can we eliminate duplicate rows from flatfile,explain?
Answers were Sorted based on User's Feedback
Answer / nagaraj.g
using sorter transformation for distinct in a flat files
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / veera reddy
By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.
| Is This Answer Correct ? | 6 Yes | 5 No |
Answer / seshagiri
veere reddy,
Dynamic lookup will not work for flat file only static
lookup will work for a flat file
| Is This Answer Correct ? | 2 Yes | 3 No |
what are the difference between Informatica 7.1 and 8.1?
how can i invoke pmcmd in command line prompt
Explain the informatica workflow?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
What is different between the data warehouse and data mart?
what is song in infrmatica...?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
What do you understand by a term domain?
in what type of scenario bulk loading and normal loading we use?
What are the differences between source qualifier and joiner transformation?