Does an informatica transformation support only aggregate expressions?
No Answer is Posted For this Question
Be the First to Post Answer
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?
How do you implement unconn. Stored proc. In a mapping?
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?
How will you display "Mr" for male & "Mrs" for female in target table?
What is a passive transformation?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
Can we create a Integration service without a Repository service and vice versa?
can we use bulk loading when we use look in mapping
How to load last 10 records of flat file in to the target?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the new features in Informatica 5.0?
How do you manage the Parameter files while migrating your data from one environment to another environment?