Answer Posted / avru.bal

we can join the 2 flat files by using filerepsitory..save
both files in one directory gve the path name c:\.txt and
provide default type=oracle then apply,
in session properties provide
source file directory:c:/txt
source file type:indirect
provide target connection..so that we can join the both
files without using joiner n lookup

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1340

---

Write the unconnected lookup syntax and how to return more than one column.

1147

---

What is a grid in Informatica?

1116

---

Quickly characterize reusable change?

1182

---

How to load a Dimension ? and how to load a fact table?

1458

---

What are the components of workflow manager?

1153

---

Explain joiner transformation in informatica

1171

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7586

---

Explain about Informatica server process that how it works relates to mapping variables?

1126

---

What will be the approach?

1037

---

What is a predefined event?

1134

---

What are the issues you have faced in your project? How did you overcome those issues?

2412

---

What is informatica worklet?

1115

---

How big was your fact table

1859

---

What is the reusable transformation?

1100

---