Sign Up Login


  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

Define enterprise data warehousing?

0 Answers  

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

what is threshold error in informatica?

1 Answers   TCS, Wipro,

what is mean by grouping of condition column in lookup transformation?

1 Answers  

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

What are the performance considerations when working with aggregator transformation?

0 Answers  

How might you approve all mappings in the archive all the while?

0 Answers  

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

what is lookup ?

7 Answers  

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

For more Informatica Interview Questions Click Here
Categories