Answer Posted / tshiwela

you can perform increamental load by using auxiliary
parameters.

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

4160

---

What is transformation?

1099

---

What are the different lookup cache(s)?

1118

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1901

---

Can informatica load heterogeneous targets from heterogeneous sources?

1185

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2744

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1579

---

Briefly explain the aggregator transformation?

996

---

How to open an older version of an object in the workspace?

1203

---

Under what condition selecting sorted input in aggregator may fail the session?

1123

---

Describe data concatenation?

1081

---

What is informatica worklet?

1063

---

What is a filter transformation and why it is an active one?

968

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2159

---

What are the restrictions of union transformation?

1039

---