List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

---

Can you create a flatfile target

3 Answers   ABC,

---

Whats the difference between $, $$, $$$

9 Answers  

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

Can informatica load heterogeneous targets from heterogeneous sources?

1 Answers  

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

---

How to recover the standalone session?

2 Answers  

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1 Answers  

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---