What is souce qualifier transformation it is active or
passive

Answer Posted / smarati

It is active transformation because,

- we can do sql override
- select distinct option, which reduces the number of rows.
- we can use join condition

All the above increases/decreases the number of rows, so SQ
is active.

Thanks
Som

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between informatica 7.0 and 8.0?

569


Name the different lookup cache(s)?

712


Clarify the aggregator change?

598


How to use procedural logic inside infromatica?

640


What are the components of the workflow manager?

642






Briefly describe lookup transformation?

602


How might you approve all mappings in the archive all the while?

602


What do you mean by enterprise data warehousing?

649


What is the function of union transformation?

621


Where can we find the throughput option in informatica?

603


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3455


differences between service based and product based?

1568


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

672


How to load a Dimension ? and how to load a fact table?

957


Define mapping and session?

587