can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

---

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

---

What are the static cache and dynamic cache in informatica?

0 Answers  

---

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

---

How to extract original records at one target & Duplicate records at one target?

12 Answers  

---

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

what transformations are used for Variable port?

2 Answers  

---

where to store informatica rejected data?

0 Answers  

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---