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
- 18390 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 |
What is an unconnected transformation?
Tell me one complex query in oracle ?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
Why the workflow is failed after running two hours in informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
What is informatica?
Can you create a flatfile target
What is the Router transformation?
"Change cache" in Informatica ?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
sample mappings for scd1,scd2 and scd3
Teradata 
