Answer / prasad_bestha

source table

col1 col2
101 1-a
102 1-a,2-ab
103 1-a,2-ab,3-abc


target table
col1 col2 col3
1 101 a
2 102 a
3 102 ab
4 103 a
5 103 ab
6 103 abc

Different types of Power center errors?

1 Answers   Cinterco, IBM,

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

---

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

What are the different components of powercenter?

0 Answers  

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

difference between shortcut and reusable transformation?

2 Answers  

---

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

---

What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---