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
- 11774 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
EXL informatica Questions
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is a node in Informatica?
Define Pmrep command?
How do we call shell scripts from informatica?
What is informatica etl tool?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Difference between Data and Index Caches?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How you can differentiate between connected lookup and unconnected lookup?
how to load rows into fact table in data warehouse
Parameter and variable differences
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Whats the difference between informatica powercenter server, repositoryserver and repository?
