Answer Posted / raghu

TAKE EXPRESSION TRANSFORMATION AND DOUBLE CLICK ON THE
EXPRESSION TRANSFORMATION AND ADD TWO NEW PORTS
1.SEQ
2.SEQ_OUT

1.IN THE SEQ PORT CHECK V=VARIABLEPORT THERE YOU MENTION
EXPRESSION SEQ+1.
2.IN THE SEQ_OUT PORT CHECK O=OUTPUTPORT THERE YOU MENTION
EXPRESSION IIF(ISNULL(SEQ),O,SEQ)
IT WILL GIVE CORRECT RESULT

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1285

---

How can one identify whether mapping is correct or not without connecting session?

1457

---

What is the need for an etl tool?

1070

---

What is meant by incremental aggregation?

1111

---

Explain the scenario which compels informatica server to reject files?

1172

---

Please let me know how to make encryption and decryption with example?

1908

---

How to delete duplicate row using informatica?

1051

---

What is blocking transformation?

1152

---

What is the function of union transformation?

1140

---

Describe an informatica powercenter?

1131

---

Differentiate between joiner and lookup transformation?

1105

---

Explain sql transformation in script mode examples in informatica

1142

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1130

---

What is aggregate cache in aggregator transformation?

1151

---

what is diff b/t sorter t/r and agg have the option sorter property...

2184

---