Interested to Buy Any Domain ? << Click Here >> for more details...
i having mapping
emp---> sq_emp--->target
using this mapping i have to load dept table values into
target... (condition assume there is no primary and foreign
key relation between emp(table x) and dept (table Y))
- 5 Answers
- 9667 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / babu
U CAN WRITE SQL OVERRIDE( SELECT
DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC FROM DEPT)
AND U CONNECT SOURE TO TARGET ONLY 3 PORTS THOSE DATA TYPES
MUST BE MATCHED.
EMP-->SQ_EMP---->TRG
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are the restrictions of union transformation?
how to create user defined function (udf) in informatica
How does the aggregator transformation handle null values?
What is the difference between a connected look up and unconnected lookup?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
can we override a native sql query within informatica? How do we do it?
what is unit testing?tell me proceedure
What are Dimensional table?
waht type of interface is used for testing the data in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How do you load first and last records into target table?
What are the designer tools for creating transformations?
Differences between connected and unconnected lookup?
How to do unit testing in informatica? How to load data in informatica ?
