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
What is rank transform?
difference between informatica 8.1.1 and 8.6
What are the issues you have faced in your project? How did you overcome those issues?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Mention few advantages of router transformation over filter transformation.
What is meant by lookup transformation? Explain the types of lookup transformation?
Define enterprise data warehousing?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is the size of your data warehousing?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Differentiate between a database and data warehouse?
How does a rank transform differ from aggregator transform functions max and min?
What is persistent lookup cache?
Differentiate between reusable transformation and mapplet.
What are the steps involved in the migration from older version to newer version of Informatica Server?