After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

---

Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  

---

How can u stop a batch?

2 Answers  

---

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

What if the source is a flat-file?

0 Answers  

---

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

---

What is sql query override? When did u use sql query override?

1 Answers   TCS,

---

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 Answers  

---

Can we run session without using workflows?

5 Answers   TCS,

---

Why we use partitioning the session in informatica?

2 Answers  

---