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

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???

Question Posted / ravikumar2614

5 Answers
11386 Views
Wipro, I also Faced
E-Mail Answers

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

What is informatica metadata and where is it stored?

931

What are the tuning techniques you applied during your last project

1962

What are the different transaction levels available in transaction control transformation?

1114

Can we override a native sql query within informatica?

984

What do you mean incremental aggregation?

1006

what are the deliverables?in your project?

2084

What is dimensional table? Explain the different dimensions.

1108

Describe an informatica powercenter?

1027

Is it possible to define a single node as a Gateway node as well as worker node?

1053

How can repository reports be accessed without sql or other transformations?

1154

Explain dynamic target flat file name generation in informatica

1005

where to store informatica rejected data?

1045

What is the sql query overwrite in source qualifier in informatica

1023

Enlist the various types of transformations.

949

Why update strategy and union transformations are active? Explain with examples.

1172