Answer Posted / nagasundar

please cc to my id also.My id is nagasundarsai@gmail.com

what is session partitioning?

2205

---

dimension object created in oracle can be imported in designer?how?

3060

---

What is meant by incremental load?

1163

---

what is data modeling?

2360

---

How to fine tune mappings?

997

---

What are the three tiers in etl?

1172

---

what is the use of server manager?

2199

---

Explain about hash partitioning?

1052

---

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

1000

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1948

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2009

---

Explain the difference between etl tool and olap tools?

967

---

Define Dynamic push down optmization?

2350

---

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2589

---

what is the difference steps for data modeling?

2203

---