Answer Posted / imran

Thanks Hari...

What are the components of Informatica? And what is the purpose of each?

1108

---

How to generate sequence numbers using expression transformation?

1145

---

Is it possible to create multiple domains on a single Informatica server?

1288

---

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

4250

---

What is joiner transformation?

1065

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2251

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1197

---

How to create or import flat file definition in to the warehouse designer?

1130

---

What do you mean by channel change?

1105

---

explain one complex mapping with logic? sales project?

6730

---

What is the need of etl tools?

1180

---

What is the function of union transformation?

1201

---

What does update strategy mean, and what are the different option of it?

1140

---

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

1645

---

State the differences between sql override and lookup override?

1283

---