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 different options available for update strategy?
Explain informatica architecture - version 8 / 9
Performance tuning in UNIX for informatica mappings?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are connected or unconnected transformations?
How to convert multiple rows to single row (multiple columns) in informatica
server hot-ws270 is connect to Repository B. What does it mean?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is olap (on-line analytical processing?
Partition, what happens if the specified key range is shorter and longer
What is a filter transformation?
Explain the features of connected and unconnected lookup.
What do you understand by a term domain?
Can informatica load heterogeneous targets from heterogeneous sources?