Answer Posted / bsgsr

duplicate records can be eliminated the following ways:

1) by using select distinct option
2) by over riding sql with group by port on the column
which gets duplicate values ( P_key column)
3) by connecting the source to an expression transformation
and flagging the duplicate records to another target by
writing an expression in the exp editor

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

1023

---

tell me few points when u become TL

2563

---

when will use SQL override in a lookup transformation?

2298

---

how would u estimate the size of Aggregator transform data and index cache?

2417

---

Explain the key challenges that you face while performing etl testing.

1016

---

how do u set partition points in the mapping?

2603

---

What is the difference between round-robin partitioning and hash partitioning?

974

---

where is the cache (lookup, index) created and how can you see it.

2017

---

How many types of transformations supported by sorted input?

1227

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1958

---

What is cube grouping?

1089

---

Explain etl mapping sheets?

1082

---

How to delete data which is not in source table?

1347

---

What is etl process. How many steps etl contains explain with example?

962

---

Explain the use lookup tables and Aggregate tables?

978

---