how will you remove the duplicate records from flat file
without using sorter?
Answers were Sorted based on User's Feedback
Answer / 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|
Answer / sathish
use aggregater T/R after source qualifier select all ports in group by clause it will removes the duplicates
|Is This Answer Correct ?||5 Yes||2 No|
Answer / 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|
Answer / sathish
put primary key to target it will reject duplicate rows
|Is This Answer Correct ?||1 Yes||4 No|
Answer / suren
by setting option distinct option
|Is This Answer Correct ?||2 Yes||5 No|
what is diff between grep and find
Do you have knowledge in ralph kimball methodology
what is the exact meaning of domain?
how to through logic of informatica using the push down optimization into oracle.
what is parallel querying and what r hints.
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
Can you copy the batches?
What is DTM process?
comonly how meny mappings r there in Banking projects?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
What is the Router transformation?
what is the process of target load planing?