Answer Posted / sham

we can't sum aggregate function in Exp T/F.i.e it is not
possible to use sum() in expression T/F. so go through Agg T/F
....

Group by month
o/p port-------> sum(sal)

I have a flat file, want to reverse the contents of the flat file

1124

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1063

---

How we can create indexes after completing the load process?

1156

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1089

---

How to update source definition?

1082

---

difference between informatica 8.1.1 and 8.6

3675

---

list out all the transformations which use cache?

1180

---

What is a pre-defined event and user-defined event?

1037

---

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

4158

---

Describe data concatenation?

1075

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2163

---

How many transformations can be used in mapplets.

1932

---

What is the use of transformation?

994

---

What is the function of look up transformation?

1123

---

Explain in detail scd type 2 through mapping.

1039

---