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

what is the complex transformation you used in informatica

2621

---

-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?

5871

---

Informatica settings are available in which file?

1035

---

Target increases every day even though no new record was inserted

1621

---

Did u used latest transformations of 8.6.0? for what?

1924

---

Does an informatica transformation support only aggregate expressions?

1084

---

Explain in detail about scd type 1 through mapping.

1622

---

What is a router transformation?

1208

---

What are the different transaction levels available in transaction control transformation?

1269

---

What are the restrictions of union transformation?

1084

---

How to handle decimal places while importing a flatfile into informatica?

1236

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1156

---

What is resilience time?

1220

---

Which files are created during the session rums by informatics server?

1229

---

Quickly characterize reusable change?

1179

---