How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

---

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

2 Answers   HCL,

---

what is plsql table?

2 Answers  

---

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

---

What is target designer and target load order?

0 Answers  

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,

---

How to retrieve last two days updated records?

4 Answers  

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

---

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

---