I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

How to update a particular record in target with out running whole workflow?

0 Answers  

---

What is informatica? Why do we need it?

0 Answers  

---

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

---

How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,

---

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

---

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

---