Does an informatica transformation support only aggregate expressions?


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

Post New Answer

More Informatica Interview Questions

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?

1 Answers   IBM,


How do you implement unconn. Stored proc. In a mapping?

1 Answers  


Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

2 Answers   Deloitte, TCS,


How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  


What is a passive transformation?

0 Answers   Informatica,






What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,


Can we create a Integration service without a Repository service and vice versa?

0 Answers  


can we use bulk loading when we use look in mapping

1 Answers   TCS,


How to load last 10 records of flat file in to the target?

5 Answers   iNautix,


if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  


What are the new features in Informatica 5.0?

1 Answers  


How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  


Categories