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
- 9857 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 is data movement mode in Informatica and difference between them?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the issues you have faced in your project? How did you overcome those issues?
What is an unconnected transformation?
What are the new features of informatica 9.x developer?
What is union transformation in informatica?
What is the difference between source qualifier transformations source filter to filter transformation?
can u any challenge your project?
How to improve the performance of a session using sorter transformation?
How are the sources and targets definitions imported in informatica designer?
can you please explain me pre session and post session options?
EXL informatica Questions
How to generate sequence numbers using expression transformation?
How do you load only null records into target? Explain through mapping flow.
wf dont have integration severances how you can run?
