Source Qualifier is an active t/r but there is no change of
row count then y should we called it active t/r & Router ,
sorter some times no change in row count then Y we called
its active t/r?
- 2 Answers
- 11212 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravindra
A transformation is active does not mean that it always
change number of rows. An active transformation can have
passibility to change the number of rows.
In Source Qualifier we can do SQL-override to limit the
number of rows in whare condition, Sorter can remove the
duplicates when select the property checkbox Distinct, In
Router you can only extract the records from selected
(filtered) group. So the number of rows can be impacted.
Expression is an example for passive transformation. Never
change number of rows.
| Is This Answer Correct ? | 18 Yes | 1 No |
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What are the basic needs to join two sources in a source qualifier?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
Using Connected or unconnected lookup for performance wise which one is preferable?.
can we import source table without using source qualifier? if yes then how? if no then why?
what are the types of facts with Examples?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
how to get max value record into one target and remaining records into another target?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
What is the need of etl tools?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what is shared Cache. when we will use shared Cache?
Teradata 
