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 |
in reporting we add some new objects,how we get the count of the newly added objects to the report
what are the unix commands to start the wrk flow ?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
What differs when we choose the sorted input for aggregator transformation?
without matching columns in two tables. how can you join
What is the scenario which compels informatica server to reject files?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Name the different lookup cache(s)?
Plz can any one say me how to get the informatica certification materials and dumps
Which transformation should u need while using the cobol sources as source defintions?
what is incremantal aggregation?