Answer Posted / raj

Flat file is a text file.give some data in note pad using
delimiter or fixed width. later import it into designer
from source analyzer sources-->import from file.

next declare the properties in session
file directory: give the path(c:\)
file name: emp.txt
under mapping tab for source.

What is the use of an aggregator cache file?

1144

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1219

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

984

---

Performance tuning( what you did in performance tuning)

1910

---

Difference between Data and Index Caches?

1096

---

permutations of mapplet

2456

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2152

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1987

---

What is the meaning of up gradation of repository?

1899

---

To import the flat file definition into the designer where should the flat file be placed?

1007

---

Separate from an archive server and a powerhouse?

908

---

Explain the pipeline partition with real time example?

1085

---

What is the need for an etl tool?

1012

---

What is the command used to run a batch?

996

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1197

---