how will you remove the duplicate records from flat file
without using sorter?
- 7 Answers
- 16839 Views
- I also Faced
- E-Mail Answers
Answer Posted / sathish
put primary key to target it will reject duplicate rows
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Which transformation should we use to normalise the COBOL and relational sources?
How to load last n records of file into target table - informatica
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
Enlist the advantages of informatica.
can u any challenge your project?
without table how to come first record only in oracle?
Parameter and variable differences
How do you change a non-reusable transformation to reusable transformation?
What is event and what are the tasks related to it?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How are indexes created after completing the load process?
What are the different versions of informatica?
What is union transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
can we override a native sql query within informatica? How do we do it?
