how will you remove the duplicate records from flat file
without using sorter?
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
What do you mean by filter transformation?
What is domain and gateway node?
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
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is dimensional table? Explain the different dimensions.
As union transformation gives UNION ALL output, how you will get the UNION output?
How many ways are there to do 'remove duplicate records in informatica'?
Explain the mapping variable usage example in informatica
What are the components of workflow manager?
Explain incremental aggregation in informatica
What is dimensional table?
Explain why we use partitioning the session in informatica?
What are the components of the workflow manager?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks