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


Please Help Members By Posting Answers For Below Questions

What is rank transform?

762


difference between informatica 8.1.1 and 8.6

3466


What are the issues you have faced in your project? How did you overcome those issues?

2099


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?

764


Mention few advantages of router transformation over filter transformation.

842


What is meant by lookup transformation? Explain the types of lookup transformation?

752


Define enterprise data warehousing?

878


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

1920


what is the size of your data warehousing?

1870


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

9459


Differentiate between a database and data warehouse?

906


How does a rank transform differ from aggregator transform functions max and min?

934


What is persistent lookup cache?

796


Differentiate between reusable transformation and mapplet.

859


What are the steps involved in the migration from older version to newer version of Informatica Server?

1842