Answer Posted / soumen

Little corrections ---->
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), sum(v_month1),
sum(v_month2), sum(v_month2)

Now forward these 5 cols to Target.

What are the steps involved in the migration from older version to newer version of Informatica Server?

2154

---

Enlist the tasks for which source qualifier transformation is used.

1075

---

Write the unconnected lookup syntax?

1133

---

Write the different tools in the workflow manager?

1119

---

How to call shell scripts from informatica?

1044

---

What are some examples of informatica etl programs?

990

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1140

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1734

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8265

---

How to load the data from people soft hrm to people soft erm using informatica?

1070

---

What is persistent lookup cache?

1100

---

What is a filter transformation and why it is an active one?

1019

---

How can we use batches?

1066

---

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 does “tail –f” command do and what is its use as an Informatica admin.

1147

---