Answer / swetha

Source name

Database location

Column names

Datatypes

Key constraints

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

why we use materialized view over view?

1 Answers   Zensar,

---

What is critical mapping?

2 Answers  

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

Explain the aggregator transformation?

0 Answers  

---

what are challenges that you faced in testing? give solution to it?

1 Answers  

---

What is mapplet in informatica?

0 Answers  

---

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

---

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, 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,

---