Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

how to obtain performance data for individual transformations.

2 Answers  

what is mystery dimension?

1 Answers  

How to delete duplicate row using informatica?

0 Answers  

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

What are the different types of olap? Give an example?

0 Answers  

Difference between task flow and linear task flow

0 Answers  

What is the use of code page?

0 Answers  

How we can confirm all mappings in the repository simultaneously?

1 Answers  

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories