Interested to Buy Any Domain ? << Click Here >> for more details...
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???
- 5 Answers
- 11552 Views
- Wipro, I also Faced
- E-Mail Answers
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 is the size of u r source(like file or table)?
What is informatica?
What does refresh system mean, and what are its distinctive choice?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain dynamic target flat file name generation in informatica
Where can we find the throughput option in informatica?
What are the tasks that source qualifier perform?
What is informatica metadata and where is it stored?
Explain scd type 3 through mapping.
What is a passive transformation?
What are data-driven sessions?
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.
Differentiate between reusable transformation and mapplet.
How to convert multiple rows to single row (multiple columns) in informatica
Explain the etl program with few examples.
