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.

How do you load first and last records into target table?

1101

---

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

1048

---

What are active transformations.

1596

---

How to extract the informatica rejected data?

1164

---

Can we get 1st record through Informatica(without sequence number).

1410

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1896

---

have u done any performance tuning? how u ll do?

2249

---

whats the logic to load the lower level of granularity of data to fact table.

2208

---

what are the deliverables?in your project?

2085

---

What is the reusable transformation?

1008

---

How do we call shell scripts from informatica?

1014

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2254

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1589

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1928

---

What are the tasks that source qualifier perform?

1032

---