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 monster dimension plz give me one example

2 Answers   EDS,

---

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

---

what is the architecture of any Data warehousing project?

5 Answers   IBM,

---

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

---

How to call shell scripts from informatica?

0 Answers  

---

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

---

How many numbers of sessions can one group in batches?

0 Answers  

---

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

---

Differentiate between joiner and lookup transformation?

0 Answers  

---

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,

---

What is synonym?

2 Answers   Patni,

---