I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

What is olap (on-line analytical processing?

0 Answers  

---

Can we update the data in flat file using update strategy?

3 Answers  

---

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

---

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

---

---

How does a sorter cache works?

0 Answers  

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

Which kind of index is preferred in DWH?

2 Answers  

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

---

Tell me about informatica architecture.

2 Answers   TCS,

---

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,

---