Answer Posted / balu

A fact table without Numeric data is called factless fact
table

How can you generate reports in informatica?

1035

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

---

what is size of u r database?

2311

---

What are the tasks that source qualifier perform?

1106

---

Does an informatica transformation support only aggregate expressions?

1042

---

What is meant by incremental aggregation?

1106

---

Performance tuning( what you did in performance tuning)

1988

---

What is mapping debugger?

1016

---

What is rank transformation in informatica

1179

---

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

4160

---

What is decode in static cache?

1180

---

What is an aggregator transformation?

1096

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1049

---

How will the document be delivered to me?

1085

---

What is workflow monitor?

1062

---