Answer Posted / prabodh

S-->SQ-->SORTER-->EXP-->AGG-->TARGET
Sort on the firt port,in exp check prev and curr value by
using var ports,if same concat them ,u will get
101 a
101 a b
101 a b c
101 a b c d

from the Exp trans ,group by first port in the Agg trans ,u
will get last row i.e 101 a b c d.

How is union transformation utilized?

948

---

What are the mapping parameters and mapping variables?

1082

---

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

1056

---

What if the source is a flat-file?

1041

---

Explain lookup transformation in informatica

1002

---

What are the guidelines to be followed while using union transformation?

1063

---

What are the main issues while working with flat files as source and as targets ?

1092

---

Differentiate between source qualifier and filter transformation?

1508

---

list out all the transformations which use cache?

1111

---

Enterprise data warehouse your projects phase by phase explain?

1854

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2506

---

Write the program through which the records can be updated?

933

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1048

---

lookup transformation with screenshots

3938

---

What are the components of Informatica? And what is the purpose of each?

980

---