what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

Write the advantages of partitioning a session?

0 Answers  

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

What is target update override

2 Answers   CTS,

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

What are active transformations.

0 Answers  

---

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

---

What are the different types of Type2 dimension maping?

1 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,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

---