Answer Posted / soumen

Use following method --

sq_source --> exp_tans --> agg_trans --> target

exp_trans --> add 3 variable --
v_month1 == iif(month='jan', amount, 0)
v_month2 == iif(month='feb', amount, 0)
v_month3 == iif(month='mar', amount, 0)

agg_trans --> add 5 cols from exp_trans --
year(check group by), account(check group by), v_month1,
v_month2, v_month2

waht type of interface is used for testing the data in informatica

2302

---

What are some examples of informatica etl programs?

990

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1143

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2261

---

What is the fact table?

1141

---

What are the databases that informatica can connect to windows?

1103

---

How we can create indexes after completing the load process?

1204

---

What does command task mean?

1218

---

How to improve the performance of a session using sorter transformation?

1191

---

what is unit testing?tell me proceedure

2279

---

How does the aggregator transformation handle null values?

1197

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1115

---

What is dimensional table? Explain the different dimensions.

1256

---

What are connected or unconnected transformations?

1175

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1695

---