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
- 18458 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 |
How can we remove the duplicates from flat file source?
can we import source table without using source qualifier? if yes then how? if no then why?
How to load last n records of file into target table - informatica
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
What is the difference between SOURCE and TARGET BASED COMMITS?
What are parallel querys and query hints?
What are the different options available for update strategy?
How can you define user defied event?
how to remove staging area
What are the types of maping in Getting Started Wizard?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
wht target override?wht advantages it has compare to target update?
Teradata 
