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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

0 Answers   Thomson,


Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

0 Answers   Cap Gemini,


How we can see table structure?

2 Answers   iGate,


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.

0 Answers  


what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers  






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

0 Answers  


what is the difference between cardinality and Nullability?

0 Answers  


what is SMP AND MPP?

8 Answers  


What is staging area referring to?

0 Answers  


Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.

3 Answers   TCS,


Two different admin users created for repository are________and_________.

1 Answers  


Define Dynamic push down optmization?

0 Answers   HP,


Categories