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  

---

Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

0 Answers  

---

What is Relational Integrity?

1 Answers  

---

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

0 Answers  

---

In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

3 Answers   Accenture,

---

What is meant by incremental load?

0 Answers  

---

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers  

---

Explain do we need an etl tool? When do we go for the tools in the market?

0 Answers  

---

working of line item dimension......pls,tell overall flow

1 Answers  

---

Explain me ETL project architecture in Detail?

0 Answers   Infosys,

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

0 Answers  

---