Answer Posted / sushma

you can use SQL transformation

Explain joiner transformation in informatica

1131

---

What is the commit type if you have a transaction control transformation in the mapping?

1036

---

Whats there in global repository

1697

---

How to handle decimal places while importing a flatfile into informatica?

1193

---

What is the sql query overwrite in source qualifier in informatica

1097

---

difference between informatica 8.1.1 and 8.6

3683

---

What is the difference between a connected look up and unconnected lookup?

971

---

What is a sequence generator transformation?

1025

---

How to load last n records of file into target table - informatica

1083

---

Is stop and abort are same in informatica?

1006

---

What is a joiner transformation?

998

---

What is joiner transformation in informatica?

1048

---

How can we delete duplicate rows from flat files?

1231

---

How to differentiate between the active and passive transformations?

1171

---

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

4167

---