Interested to Buy Any Domain ? << Click Here >> for more details...
how will you remove the duplicate records from flat file
without using sorter?
- 7 Answers
- 18748 Views
- I also Faced
- E-Mail Answers
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 are the main issues while working with flat files as source and as targets ?
What is domain in terms of informatica?
What does cheating measurement mean?
can we override a native sql query within informatica? How do we do it?
To import the flat file definition into the designer where should the flat file be placed?
What is data movement mode in Informatica and difference between them?
What is domain and gateway node?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to create a non-reusable instance of reusable transformations?
How would you join a node to the already existing domain?
What is flashback table ? Advance thanks
Do you find any difficulty while working with flat files as source and target?
What are batches?
What does command task mean?
What are the types of schemas we have in data warehouse and what are the difference between them?
