Answer / swetha

Two ways

1.Drag the port from another transforamtion

2.Click the add buttion on the ports tab.

What is the need for an etl tool?

0 Answers  

---

Implementation methodology

0 Answers  

---

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  

---

How to recover sessions in concurrent batches?

3 Answers  

---

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

need for registering a repository server

1 Answers  

---

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---

What is synonym?

2 Answers   Patni,

---