Answer Posted / shankar

if there is primary key there then this cant be done. we get an error 'unique constraint violated'error. hence very less scope here. if we can assign any i.d then there might be some scenarios where we can do this.

What are some examples of informatica etl programs?

942

---

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

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1975

---

Write the prerequisite tasks to achieve the session partition?

1158

---

Mention few advantages of router transformation over filter transformation.

1023

---

What are the popular informatica products?

1012

---

What are the features of complex mapping?

1159

---

Explain how many types of dimensions are available in informatica?

1098

---

Mention some types of transformation?

1048

---

What are multi-group transformations?

1096

---

What is persistent lookup cache?

1029

---

What are different types of transformations available in informatica?

992

---

What are the tasks that can be performed using sq?

1091

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1079

---

What are the different versions of informatica?

1275

---