Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicate records in informatica mapping?
Explain with an example....
- 1 Answers
- 8480 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 surrogatekey ? In ur project in which situation u has used ? explain with example ?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
What are parallel querys and query hints?
If the records doesnt satisfy the filter condition where will it go?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
what is metadata?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
Scheduling properties,whats the default (sequential)
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
HOW DO YOU CONNECT TO REMOTE SERVER ?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
Teradata 
