list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 Answers  

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2 Answers  

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers  

---

you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  

---

How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 Answers  

---

what are the parts of Informatica server ?

1 Answers   GE,

---

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

2 Answers   Accenture, Saama Tech, TCS,

---

Is apache nifi an etl tool?

0 Answers  

---

Which transformation we use to convert 'NA' to 'Not Available'

0 Answers  

---

how many steps are there in etl process?

0 Answers  

---

Difference between flat files and relational sources?

2 Answers  

---

what is the difference steps for data modeling?

0 Answers  

---