Answer Posted / muskaan

Plz gv me a ans...

what is the difference steps for data modeling?

2139

---

In Which Transformation We Can Use Having Clause In Informatica?

1242

---

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

2124

---

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

949

---

What is the difference between round-robin partitioning and hash partitioning?

973

---

Explain me ETL project architecture in Detail?

2370

---

explain the methodology of Data Warehousing?(Polaries)

2017

---

what is pmrep command?

2435

---

State the differences between shortcut and reusable transformation

1056

---

What are dimensions?

1060

---

what is the difference between cardinality and Nullability?

3453

---

Explain the key challenges that you face while performing etl testing.

1009

---

where we cannot use sorter Transformation. if we use then we will not get correct data?

2199

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1772

---

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

1195

---