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 a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
How to improve the session performance in informatica?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
why we are using level option in normalizer transformation
Can you please mail me a copy of Informatica Certification Exam dumps to email@example.com
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
which is better perfomancewise lookup or joiner and why?can anyone give example?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
In joiner, how to load Master table in Target?
What are the rank caches?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
Can you please mail me a copy of Informatica Certification Exam dumps to firstname.lastname@example.org