Answer Posted / parthu

Plz send it to me as well
ID: sparthu09@gmail.com

what is the difference between cubes and package in cognos

4890

---

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1821

---

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

888

---

when will use SQL override in a lookup transformation?

2229

---

Identifying the bottlenecks in various components of Informatica and resolving them.

1872

---

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1135

---

What is grain of fact?

901

---

how do u really know that paging to disk is happening while u are using a lookup transform?

1931

---

What are the modules in Power Mart?

894

---

What is data modeling and data mining?

919

---

What is fact? What are the types of facts?

1011

---

Explain etl?

938

---

What are the steps involved in etl process?

952

---

Explain what is etl process? How many steps etl contains explain with example?

831

---

Explain what are the various etl tools in the market?

883

---