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 / ravikumar2614

if we didnt put any filter condition in trt then it will load all 3 records.

Note: For all transformations having passive nature by default.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to implement security measures using repository manager?

606


tell me 5 session failure in real time how can you solve that in your project?

1632


Tell me about Propagate functions in informatica

524


What is data caches/ index caches?

615


Explain the difference between a data warehouse and a data mart?

600






Explain in detail about scd type 1 through mapping.

589


Whats the difference between informatica powercenter server, repositoryserver and repository?

676


What is blocking transformation?

720


what is $$$$?

1738


Differentiate between router and filter transformation?

613


Explain joiner transformation in informatica

668


What are the issues you have faced in your project? How did you overcome those issues?

1914


Define pmcmd command?

624


Design time, run time. If you don't create parameter what will happen

1428


What is a filter transformation?

568