Answer Posted / naresharavetis

if u use aggregator t/r without using group by function u
get one summirized result but group by option allows u get
deatil result.
for example .without using groupby u want see a releince
store sales .u will get sales of whole store but when uuse
group by u get imtemized sales result
storecode itemname sales
101 vegetable 500
101 vegetables 700
101 electronics 5000
101 electronics 10000
101 cooldrinks 200
101 cooldrinks 500

result without groupby: store sales:17400
result with groupby: vegetables sales :1200
electronics sales: 15000
cooldrinks sales: 700

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

---

How can we store previous session logs?

1083

---

can anyone explain me about retail domain project in informatica?

7948

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2123

---

What happens when a session fails and you click on recover?

1120

---

What are the static cache and dynamic cache in informatica?

1193

---

permutations of mapplet

2511

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1975

---

What is the need of etl tools?

1120

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5794

---

Design time, run time. If you don't create parameter what will happen

1837

---

Explain the different dimensions.

967

---

How can we delete duplicate rows from flat files?

1223

---

What is different between the data warehouse and data mart?

1066

---

what is the complex transformation you used in informatica

2588

---