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 |
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
What is aggregator transformation in informatica?
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
What are active transformations? Name them.
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
Write the different tools in the workflow manager?
what are surrogate keys?
How can we store previous session logs?