How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,

---

In which scenario did you used pushdown optimization?

1 Answers  

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

---

Differentiate between mapping parameter and mapping variable?

1 Answers  

---

---

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

---

What is junk dimention?

3 Answers   Patni,

---

What is a stored procedure transformation?

0 Answers  

---

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,

---

can we override a native sql query within informatica? Where do we do it?

0 Answers  

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---