Answer Posted / smarati

It is active transformation because,

- we can do sql override
- select distinct option, which reduces the number of rows.
- we can use join condition

All the above increases/decreases the number of rows, so SQ
is active.

Thanks
Som

Is it possible to revert a global repository to local one and why?

1083

---

If informatica has its scheduler why using third party scheduler?

1268

---

Enlist few areas or real-time situations where informatica is required.

1088

---

What is data movement mode in Informatica and difference between them?

1139

---

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?

1070

---

how many types of dimensions are available in informatica?

1103

---

What is Cognos script editor?

4238

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

978

---

How to elaborate tracing level?

1181

---

What is a code page?

1181

---

What is status code in informatica?

1024

---

How does a sorter cache works?

1075

---

How to load the data from people soft hrm to people soft erm using informatica?

1021

---

Define enterprise data warehousing?

1208

---

What is the function of aggregator transformation?

1087

---