if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

What are the new features of Power Center 5.0?

0 Answers  

---

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,

---

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

---

Differentiate between router and filter transformation?

0 Answers  

---

What is Session and Batches?

0 Answers   Informatica,

---

what is parameter file?

1 Answers   Cap Gemini,

---

How to jion 2 tables, without using any condition?

11 Answers   Amazon,

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---