Answer / Aditya Shakya

Target Designer in Informatica is used for designing the target load process. It allows users to map and transform the output data from the source qualifier into the required format for loading into a target system like a database or a file.

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1 Answers   Cap Gemini,

---

what is update strategy transformation ?

7 Answers   TCS,

---

If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,

---

why do u use shortcuts in informatica.?

4 Answers   iFlex,

---

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

What is the difference between view and materialised view?

4 Answers  

---

tell me about your project functionality

1 Answers  

---