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

How do you migrate data from one environment to another?

1096

---

Write the program through which the records can be updated?

1007

---

scenario where i can use only concurrent execution of workflow.

3176

---

What is workflow? What are the components of workflow manager?

1179

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2725

---

How would you copy the content of one repository to another repository?

1024

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1178

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1325

---

What are the new features of informatica 9.x in developer level?

1000

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4164

---

What is depict expression change?

1125

---

If informatica has its scheduler why using third party scheduler?

1269

---

How can informatica be used for an organization?

1220

---

Does an informatica transformation support only aggregate expressions?

1043

---

Mention few advantages of router transformation over filter transformation.

1024

---