What is the difference between Active and Passive transformation?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  


in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,


write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,


i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,


(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  






Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,


1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,


What is the fact table?

0 Answers  


Enlist the advantages of informatica.

0 Answers  


while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,


How can we eliminate duplicate rows from flatfile,explain?

3 Answers  


i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  


Categories