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))
Answer Posted / ahalya inturi..
interviewer asked the this question.. i too felt that its not possible to load into target without helping primary key foreign key relation ship.. but i am looking forward for more answers.. plz if any body can...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between Data and Index Caches?
What is a repository manager?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How might you approve all mappings in the archive all the while?
What is an Integration service in Informatica?
How an expression transformation differs from aggregator transformation?
Make a note of the quantity vaults made in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the function of union transformation?
How do you load only null records into target? Explain through mapping flow.
What is the difference between STOP and ABORT options in Workflow Monitor?
Can we create a node as a gateway node and the same node can be assigned to a grid?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Implementation methodology
In which transformation you cannot drag ports into it?