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
11626 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 expression transformation?

1103

What is the reusable transformation?

1047

Can you generate sequence numbers without using the sequence generator transformation?

1123

What are the types of lookup transformation?

1081

explain about unit testing? in real time?

2206

How to create a non-reusable instance of reusable transformations?

1135

What is the need of etl tools?

1120

State the differences between sql override and lookup override?

1209

What is the difference between source qualifier transformations source filter to filter transformation?

1056

Target increases every day even though no new record was inserted

1581

what are factless facts? And in which scenario will you use such kinds of fact tables.

1810

What is Index Caches size?

1117

How can a transformation be made reusable?

1171

How to open an older version of an object in the workspace?

1207

Write the different tools in the workflow manager?

1068