how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / ajit kumar pradhan
if it is a relational source then click on source Qualifier
properties then check Distinct option.
if it is a flat file then it can't work .......
click on target defination select target menu and click
generate/execute then it come out one dialog box come out
then check primary key check box..it avoid duplicale row...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What happens when a session fails and you click on recover?
Informatica Checkpoints
Differentiate between a database and data warehouse?
What is the use of source qualifier?
How many ways are there to create ports?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What can we do to improve the performance of informatica aggregator transformation?
Explain incremental aggregation in informatica
What is InformaticaPowerCenter?
Define enterprise data warehousing?
What is the benefit of partitioning a session?
What is mapping debugger?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are the different types of repositories created using informatica?