Answer Posted / reddy

Answer:

Source --> Source qualifier --> Normalizer --> Expr -->
Agg --> target

Step 1:

Source --> Source qualifier --> Normalizer --> Expr -->

Expression Condition:

DECODE(GCID_DETAIL,1,'JAN',DECODE(GCID_DETAIL,2,'FEB',DECODE
(
GCID_DETAIL,3,'MARCH','APRIL')))


JAN 100
JAN 500
JAN 900
FEB 200
FEB 600
FEB 100
MAR 300
MAR 700
MAR 200
APR 400
APR 800
ApR 300

Step 2:

Source --> Source qualifier --> Normalizer --> Expr -->
Agg --> target

1) Group by month
2) Sum(Amount)

MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500

What are the types of presistent cache in look up tr.

2009

---

Enlist some properties of sessions.

1023

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1020

---

what is the difference between informatica6.1 and infomatica7.1

2186

---

What is dynamic cache?

974

---

How might you approve all mappings in the archive all the while?

958

---

Can u generate reports in Informatica?

1027

---

Explain the difference between a data warehouse and a data mart?

1001

---

How to create a non-reusable instance of reusable transformations?

1061

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1004

---

What does “tail –f” command do and what is its use as an Informatica admin.

1032

---

is it possible to index the data in cache of lkp transformation ?

1961

---

Please let me know how to make Data masking in informatica..

1665

---

How to join three sources using joiner? Explain though mapping flow.

1092

---

What are the data movement modes in informatica?

1082

---