Interested to Buy Any Domain ? << Click Here >> for more details...
how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 14849 Views
- I also Faced
- E-Mail Answers
Answer / nagaraju bhatraju
1.)
we can distinguish between unique and duplicate records in
informatica by using forward reference technique ,
in the sense , we can store the previous rec key value in
Variable_Port and can be compared with the previous rec key
value , but Data has to be come in sorted order on that key
column , for that we should use sorter transformation.
once if you find the duplicate rec by comparing , you can
flag that rec as dulicate and you can divert it to other
target.
2.) with out using sorter
in order to collect only unique records for flat file ,
just use aggregator before exp transformation, and check
group by on the key column where you are expecting
duplicate records. so you will get only unique records and
duplicate records will be eliminated.
| Is This Answer Correct ? | 15 Yes | 1 No |
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
In any project how many mappings they will use(minimum)?
What are the different caches used in informatica?
When will you use SQL override in a lookup transformation?
Performance wise which is better joiner or look up ? Give me with example?
What are roles and groups and benefits of using them?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is depict expression change?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What is Cognos script editor?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
Teradata 
