Answer / om

Constraint Based Load order defines load the data into
multiple targets depend on the primay key foriegn key reltion.

set the option is: Double click the session
Configue Object check the Constraint Based Loading

Answer / raja

yes it is correct.it is there in target.u enable the key.

Answer / guest

yes. both tables shuld maintain relationship. like emp dept
tables

Answer / c manojkumar

Thanks a lot.

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

---

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

diffrence between command task and control task

1 Answers   iNautix,

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

---

How would you join a node to the already existing domain?

0 Answers  

---

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---