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 are batches?

1005

---

How to call shell scripts from informatica?

932

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1925

---

What are the features of complex mapping?

1088

---

What is the difference between informatica 7.0 and 8.0?

951

---

What are multi-group transformations?

1007

---

What is the Process to creating lookup transformation in informatica

979

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2116

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1985

---

What does update strategy mean, and what are the different option of it?

1034

---

Define joiner transformation?

979

---

What is meant by query override?

1004

---

How can we improve session performance in aggregator transformation?

1038

---

What is a pre-defined event and user-defined event?

969

---

How to extract sap data using informatica?

981

---