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 / ankit kansal
Hi,
If you are using a RTR trans and defualt value is true then all the three records get loaded into the target without any problem.
http://deepinopensource.blogspot.com/
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is the size of u r source(like file or table)?
how to load rows into fact table in data warehouse
Explain the tuning lookup transformation - informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What do you mean by filter transformation?
wat are deployement groups in informatica, how it will be used for developers
Define the various join types of joiner transformation?
How to Create a folder using pmrep command?
Do you find any difficulty while working with flat files as source and target?
Can you use flat files in Mapplets.
Enlist the various types of transformations.
What is domain in terms of informatica?
What is event and what are the tasks related to it?
What is a repository manager?