how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / rkumar.etl
use aggregator transformation and group by all ports and
create one port for checking count...and pass the results
accordingly to target tables.
| Is This Answer Correct ? | 24 Yes | 3 No |
Post New Answer View All Answers
Define pmcmd command?
Explain the features of connected and unconnected lookup.
Mention some types of transformation?
What is union transformation in informatica?
How many dimensions are there in informatica?
How many ways are there to create ports?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is the difference between a repository server and a powerhouse?
What is meant by LDAP users?
According to his methodology what all you need before you build a datawarehouse
How can we use mapping variables in informatica?
What is the commit type if you have a transaction control transformation in the mapping?
What are session parameters ? How do you set them?
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain what transformation and how many are there in informatica?