What are reusable transformations in how many ways we can create them?

2 Answers  

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

---

Briefly define reusable transformation?

0 Answers  

---

what is junk dimension

4 Answers   Cap Gemini,

---

---

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

---

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

What are the mapping paramaters and mapping variables?

1 Answers  

---

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  

---

What is the difference between view and materialised view?

4 Answers  

---

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

---