Answer Posted / maneesh

To eliminate first row, simply use a counter in Expression and then Filter.

To eliminate the last row, make two pipelines with the same source
In first pipeline, use AGGREGATOR without any Group By ports In second pipeline, join it with the above with JOINER. Use and Outer Join and then other than that Joined row .. load all the rows.

What do you mean by enterprise data warehousing?

1063

---

How can we update a record in the target table without using update strategy?

1144

---

Mention few advantages of router transformation over filter transformation.

1023

---

can anyone explain me about retail domain project in informatica?

7946

---

What is a sorter transformation?

1102

---

What are the static cache and dynamic cache in informatica?

1189

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2131

---

Describe expression transformation?

1122

---

What is the reusable transformation?

1047

---

How do you load only null records into target?

1213

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1626

---

What is the fact table?

1068

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1135

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1048

---

What does update strategy mean, and what are the different option of it?

1089

---