Answer Posted / suneelkumar.dasari

If u want to use the same look up T/R more than one time,you should use compulsory Unconnected lookup.A common use for unconnected Lookup transformations is to update slowly changing dimension tables.I know these 2 uses.

What is data caches/ index caches?

1063

---

Differentiate between reusable transformation and mapplet.

1071

---

What are the different types of olap? Give an example?

1033

---

How can we delete duplicate rows from flat files?

1204

---

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

1106

---

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

7357

---

What is Data Caches size?

1074

---

Could you explain what is enterprise data warehouse?

1118

---

What is the need for an etl tool?

1053

---

What are the components of workflow manager?

1074

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1061

---

What is data movement mode in Informatica and difference between them?

1118

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1886

---

Explain sql transformation in script mode examples in informatica

1108

---

How would you join a node to the already existing domain?

1110

---