Answer Posted / dw_worker

Heterogeneous sources - Joiner
Homogeneous sources - Source Qualifier
Find the 5 highest paid employees with in a dept - Rank
Create a summary table - Aggregator
Generate surrogate keys - Sequence Generator

Two default user groups created in the repository are____and_____.

1973

---

Give the benefits of data integration suite?

861

---

how would u estimate the size of Aggregator transform data and index cache?

2369

---

Explain about etl data integration software?

841

---

How to fine tune mappings?

874

---

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1746

---

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2019

---

can cubes contain measures ?

1979

---

what is data modeling?

1844

---

what are the session parameters? How do u set them?

1982

---

What is cube grouping?

993

---

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

882

---

What is partitioning? Explain about round-robin, hash partitioning.

894

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1904

---

How to delete data which is not in source table?

1266

---