how will you remove the duplicate records from flat file
without using sorter?
- 7 Answers
- 17407 Views
- I also Faced
- E-Mail Answers
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 / amedela chandra sekhar
SD---S.Q----EXP t/r------TGT.
add two port in exp t/r.
one is variable port v_seq expression:seq+1
one output port o_seq expression:v_seq
required ports connect to target.
| Is This Answer Correct ? | 1 Yes | 4 No |
We can use the option 'SELECT DISTINCT' in the source
qualifier.
Anybody please tell me whether this works or not.
| Is This Answer Correct ? | 5 Yes | 23 No |
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
What is the difference between OLTP and ODS?
What are mapplets? How is it different from a Reusable Transformation?
Which version configuration tool used in ur project?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
Is there any way to read the ms excel datas directly into informatica?
How to generate sequence numbers using expression transformation?
How we will implement Pushdown Optimization and Types in Informatica with better examples
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
what is the flow?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
How to load a Dimension ? and how to load a fact table?
Teradata 
