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 are the differences between source qualifier and joiner transformation?
What is workflow? What are the components of the workflow manager?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the tasks that source qualifier perform?
What is the need for an etl tool?
Can we create multiple integration service on single repository?
What is status code in informatica?
What are 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?
Plz can any one say me how to get the informatica certification materials and dumps
Explain load alternative records / rows into multiple targets - informatica
What you know about transaction control transformation?
What is rank index in rank transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?