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

how to load dimension table and fact table. plz tell me the steps.

2140

---

What are the components of the workflow manager?

1179

---

How will the document be delivered to me?

1127

---

Clarify the utilization of aggregator cache record?

1042

---

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

1195

---

What is the maplet?

1200

---

Performance tuning( what you did in performance tuning)

2053

---

How to delete duplicate row using informatica?

1086

---

What are ETL Tools?

1169

---

How can we create index after completion of load process?

1162

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1957

---

What do think which one is the better joiner or look up?

1242

---

What are the different transaction levels available in transaction control transformation?

1270

---

Explain the use of aggregator cache file?

1314

---

What is a joiner transformation?

1034

---