Answer / rkumar.etl

use user defined join option.

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

---

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

0 Answers  

---

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  

---

What are the popular informatica products?

0 Answers  

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  

---

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

---

How you prepared reports for OLAP?

0 Answers  

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---