what is the complex transformation you used in informatica


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

Post New Answer

More Informatica Interview Questions

How to Create a folder using pmrep command?

0 Answers  


For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  


How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers   IBM,


suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,


insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  






how to we create datamart?

2 Answers   HSBC,


can you use flat file for lookup table?why?

2 Answers   HCL,


If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  


How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,


What is Session and Batches?

0 Answers   Informatica,


Explain lookup transformation is active in informatica

0 Answers   Informatica,


how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,


Categories