Answer / haribabu

it is used to import data from cobol services and it converts the single record into multible output records like normalized data is converted into denormalized data.

Answer / usha

Normalizer transformation whic is used to normilize the
data.

Normalizer transformation is used to conver columns to rows.

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

How to add source flat file header into target file?

3 Answers   Logica CMG,

---

What is event and what are the tasks related to it?

0 Answers  

---

How can we create index after completion of load process?

0 Answers  

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

---

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

---

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

Which is the t/r that builts only single cache memory?

0 Answers  

---

Can you copy the batches?

3 Answers  

---