Answer / praveen

$PMBWPARAM

How would you copy the content of one repository to another repository?

0 Answers  

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

what is the difference between mapplet & stored procedure?

1 Answers  

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

---

Why update strategy and union transformations are active?

0 Answers  

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---