Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate records by using filter
transfermation?
- 3 Answers
- 7947 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
by using only filter t/r we cannot delete duplicate records.
but by using combination of aggrigator and filter t/r we can achive it
in aggrigator t/r create a new o/p port to count_rec with expression count(key column)
connect all the ports to filter and write a condition count_rec=1.now connect ports to the target
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Under what condition selecting sorted input in aggregator may fail the session?
What is a surrogate key?
What is expression transformation?
What is a sequence generator transformation?
explan ur project architecture?
What is primary and backup node?
What is lookup change?
How do you convert single row from source into three rows into target?
What is rank index in rank transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
can anyone explain me about retail domain project in informatica?
