1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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))

Question Posted / ahalya inturi

Answers were Sorted based on User's Feedback



i having mapping emp---> sq_emp--->target using this mapping i have to load dept table value..

Answer / 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

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table value..

Answer / kalim

Using SQL Overide we can reach the goal.

Is This Answer Correct ?    3 Yes 0 No

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table value..

Answer / 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

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table value..

Answer / snjsngh15

Based on the constraint based load we can load the data IT means emp table in target t1 and dept in target t2.

Is This Answer Correct ?    0 Yes 0 No

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table value..

Answer / venubyna1

question is incorrect
how to load in target two table with out PK and FK

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

What is the default join that source qualifier provides?

3 Answers   Informatica,

How we can create indexes after completing the load process?

1 Answers  

What are data-driven sessions?

1 Answers  

What are parallel querys and query hints?

1 Answers  

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  

What is the difference between a connected look up and unconnected lookup?

1 Answers  

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

For more Informatica Interview Questions Click Here
Categories