which one is better either active or passive transformation
in informatica

Answer Posted / shital.mylove@gmail.com

passive transformation

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain lookup transformation source types in informatica

785


What are the advantages of informatica?

662


What is an aggregator transformation?

721


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1689


What is source qualifier transformation in informatica?

647






Differentiate between a database and data warehouse?

752


Explain how many types of dimensions are available in informatica?

681


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1879


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6661


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1777


What is olap (on-line analytical processing?

729


What is different between the data warehouse and data mart?

717


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6640


Explain constraint based loading in informatica

748


What is repository manager?

632