How to eliminate duplicate records in informatica mapping?
Explain with an example....
Answer / venkatesh
by using aggrigator transformation we can eliminate
duplicate records in informatica
The flow will be like this
source--->aggrigator----->target
in aggrigator group by all ports then the out put is only
unique records
connect it to the target
2)we can do it by sorter also in sorter if we enable select
distinct then it will gives unique row
3)if u r source is database then u can select distinct in
sourcequalifier it self
| Is This Answer Correct ? | 23 Yes | 0 No |
What is the meaning of decode in informatica?
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
In real time scenario where can we use mapping parameters and variables?
how did u understand business requirement?
How the dimensions will be loaded?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
Which means the first record should come as last record and last record should come as first record and load into the target file?
my source is junk data how will u remove that junk data by using unix please any one replay me
Why the workflow is failed after running two hours in informatica?
How mapping parameter and variable works
Explain one complecated mapping?