If i havee 3records in my source having same deptno like
Deptid Deptno
------ ------
101 10
201 10
301 10
and i am using router TR to loading these records into
target.Then how many record'll be loaded into target???
Answer Posted / dave
All 3 records unless DEPTNO is unique constrain and then
you'll get 'Error' and only one records will be loaded
(random record Router is not sorting)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you understand by SOA of Informatica?
Name the different lookup cache(s)?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is a pre-defined event and user-defined event?
Explain target update override in informatica
How to load the data from people soft hrm to people soft erm using informatica?
What is sorter transformation?
expain about the tune parameters?
What is persistent lookup cache?
tell me the rules and responsblites in our project(my project is development)
What is meant by query override?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
update strategy transformation in informatica
What are the reusable transformations?
What are the types of presistent cache in look up tr.