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 rank transformation in informatica

1151

---

Explain load alternative records / rows into multiple targets - informatica

1136

---

How to partition the Session?

1085

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1107

---

Explain sessions. Explain how batches are used to combine executions?

1004

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2393

---

How to join three sources using joiner?

1082

---

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

1097

---

What is the benefit of session partitioning?

1096

---

what is index?how it can work in informatica

2027

---

Describe data concatenation?

1059

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1124

---

What is the commit type if you have a transaction control transformation in the mapping?

1017

---

What is the scenario which compels informatica server to reject files?

1050

---

What is xml source qualifier transformation in informatica?

1204

---