Answer / shiva

hi,
first take the .cbl files or copy books and import into
Informatica source analyzer. here you will get 2 metadata
structures like IN_ , OUT_ you can use any one as your
source datadefination in Informatica environment.

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

---

What are mapplets?

0 Answers  

---

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,

---

How do you load only null records into target?

0 Answers  

---

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 do you load only null records into target? Explain through mapping flow.

0 Answers  

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

Explain the types of lookup transformation?

0 Answers  

---

what is degenerated dimension?

1 Answers   IBM,

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---