Answer Posted / sony_infa

using session partition we can improve the performance.

In development project what is the process to follow for an etl developer from day1

1758

---

Explain what transformation and how many are there in informatica?

1023

---

What is an Integration service in Informatica?

1191

---

Different qualification between a related rotate toward the sky and isolates look upward?

1037

---

Describe the impact of several join conditions and join order in a joiner transformation?

1115

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123

---

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

1691

---

How is union transformation utilized?

1060

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282

---

How to call shell scripts from informatica?

1043

---

Different circumstance which drives informatica server to expel records?

1041

---

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

1097

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1305

---

Differentiate between a database and data warehouse?

1193

---

What is the sql query overwrite in source qualifier in informatica

1142

---