Answer / praveen

$PMBWPARAM

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---

What are the databases that informatica can connect to windows?

0 Answers  

---

What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  

---

How to enter same record twice in the target table,explain?

7 Answers  

---

what is dimension table?

17 Answers  

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

what is target load plan

2 Answers   Cap Gemini,

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

---

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

---

Which kind of index is preferred in DWH?

2 Answers  

---