Answer Posted / jz

Select Distinct Box at Source propeties level or jus
override sql in Session.

differences between service based and product based?

2020

---

What is a router transformation?

1132

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2136

---

Why filter transformation is an active one?

987

---

What is meant by query override?

1061

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1277

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2307

---

COM components can be used in Informatica

2395

---

Different qualification between a related rotate toward the sky and isolates look upward?

990

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1964

---

Global and Local shortcuts. Advantages.

2035

---

which one is better performance wise joiner or look up

1095

---

What is a stored procedure transformation?

1056

---

Enterprise data warehouse your projects phase by phase explain?

1924

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2038

---