Answer / Abhinav Kukreti

In Informatica, Maplets are pre-built mapping templates that can be used to easily create new mappings. They provide a drag-and-drop interface for configuring transformations and are designed to help users who are not experts in data integration.

Enlist some properties of sessions.

1 Answers  

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

lookup transformation with screenshots

1 Answers   TCS,

---

how to sort date field in infomatica?

2 Answers  

---

What is surrogate key?

9 Answers  

---

What are the tasks that source qualifier performs?

1 Answers  

---

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

---

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers   Hexaware,

---

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

---

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

---

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---