List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

---

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

---

How the facts will be loaded? explain

2 Answers   HCL,

---

How to create the source and target database connections in server manager?

0 Answers   Informatica,

---

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

---

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

---

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

---