Answer Posted / krishnakanth.ch

There are many ways....

1) Using the sql override in the source qualifier. To find
the even and odd. Add another column to flag the even and
odd.Like

select ID,decode( id/2,0,'E','O') FLAG FROM TABLE_NAME;

Using the router we can send them into two seperate target
tables.

What is a rank transform?

1140

---

What is substr in informatica?

1256

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2403

---

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

1756

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1960

---

Can anyone tell me the new features in Informatica 9 Version?

2203

---

How can you increase the performance in joiner transformation?

1246

---

Slowly changing dimensions, types and where will you use them

1767

---

Differentiate between Load Manager and DTM?

2206

---

Differentiate between a database and data warehouse?

1187

---

Explain the mapping variable usage example in informatica

1223

---

What is the function of aggregator transformation?

1132

---

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

1217

---

State the differences between sql override and lookup override?

1278

---

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

1298

---