what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

---

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,

---

update strategy transformation in informatica

0 Answers   Informatica,

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---

why we use datawarehouse

0 Answers   HCL,

---

Explain what transformation and how many are there in informatica?

0 Answers  

---

How to get EVEN & ODD numbers separately?

8 Answers  

---

What is active and passive transformation?

10 Answers  

---

What is the surrogate key?

0 Answers  

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

---