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


Please Help Members By Posting Answers For Below Questions

Make a note of the quantity vaults made in informatica?

551


Which transformation should we use to normalise the COBOL and relational sources?

738


how many types of dimensions are available in informatica?

559


Why do we need informatica?

554


What are the basic requirements to join two sources in a source qualifier transformation using default join?

609






The question was on time stamp. what is the difference between HH and HH24 when to use when.

1550


How are the sources and targets definitions imported in informatica designer?

666


Write the program through which the records can be updated?

512


While importing the relational source definition from the database, what are the metadata of source that will be imported?

784


How does a rank transform differ from aggregator transform functions max and min?

667


In development project what is the process to follow for an etl developer from day1

1278


What is an unconnected transformation?

659


Explain the code page compatibility?

639


what is the size of u r source(like file or table)?

1814


Target increases every day even though no new record was inserted

1103