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

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

Diffrence between static and dynamic cache

2 Answers   HCL,

Explain the aggregator transformation?

0 Answers  

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,




What is the need of etl tools?

0 Answers  

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

What do you mean by worklet?

0 Answers  

How do you set a varible in incremental aggregation

0 Answers  

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

For more Informatica Interview Questions Click Here
Categories