Answer Posted / sai.masarapu.chowdary

using normalizer transformation we can do as follows:

from source qualifier give the column to the normalizer tr
then put occur for 4 times.

put that occurs to the target. thats it..

Explain pushdown optimization and types in informatica

747

---

tell me 5 session failure in real time how can you solve that in your project?

1738

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1849

---

How to extract sap data using informatica? What is abap? What are idocs?

676

---

what is the Default Source Option For Update Strategy Transformation?

856

---

---

I have a flat file, want to reverse the contents of the flat file

787

---

How to elaborate powercenter integration service?

747

---

What is informatica worklet?

699

---

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

3604

---

Whats there in global repository

1347

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1792

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

709

---

How can we use batches?

686

---

Is it possible to use a client with different version than that of its Informatica server?

739

---

What happens when a session fails and you click on recover?

743

---