Answer Posted / ashok1729

pushdown optimization will improve the performance of the
Load...

Let's see the E.g:

Sq ---> Flter_t ----> Target
[ sal<2000 ]

....

What is olap (on-line analytical processing?

1110

---

what is mean by complex business rule ?

2218

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1113

---

How to load last n records of file into target table - informatica

1133

---

What is the function of aggregator transformation?

1135

---

What is decode in informatica?

1253

---

How does a sorter cache works?

1110

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2325

---

How to update or delete the rows in a target, which do not have key fields?

1222

---

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

1098

---

What is the session task and command task?

1115

---

How many ways are there to create ports?

1403

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1856

---

What are the uses of etl tools?

1175

---

what is unit testing?tell me proceedure

2275

---