While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

Briefly explain the aggregator transformation?

0 Answers  

---

What is aggregator transformation in informatica?

0 Answers  

---

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers   Wipro,

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

what is target update override and when we use it?

2 Answers   TCS,

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---