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 do you understand by a term domain?

671

---

Why update strategy and union transformations are active?

594

---

What are the settings that you use to configure the joiner transformation?

617

---

What is lookup change?

624

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6094

---

---

How to extract sap data using informatica?

607

---

Informatica settings are available in which file?

593

---

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

599

---

Explain lookup transformation is active in informatica

665

---

What does refresh system mean, and what are its distinctive choice?

568

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1412

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1712

---

Which transformation is needed while using the Cobol sources as source definitions?

730

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

1753

---

In warehouses how many schemas are there?

585

---