How many transformations can be used in mapplets.

0 Answers  

---

Mention few power centre client applications with their basic purpose?

0 Answers  

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

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,

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

---

What is difference between maplet and reusable transformation?

2 Answers  

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

---

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

Could you explain what is enterprise data warehouse?

0 Answers  

---

Define informatica repository?

2 Answers   Wipro,

---