interview questions

[pavansonu99]

Hi,

ca you please give me Answers for some of my interview questions.

1). If we use binary load will it import section access and variables of loding QVW file.

2) if my QVD is 8 to 9 GB how to compress it.

3) If i have 8 dimensions and 8 expressions in straight table it is loading in 3 min i want load in 20 Sec..    how to do it.

4)  what is the dimension limit option in Pivot table.

[Anonymous]

Hi pavan,

1) section access applicable on binary load,  but it doen't carry any variables along with it.

2)qvd is 8 gb means source data in more than 80gb, inthat case as far as i know remove unused columns, any key columns present in the QVD convert them into number format,if you have any dimensional data in the QVD for example if both customerID and customerName are present then create a separate QVDs for all dimensional feilds and make sure that data needs to be unique. Mostly this could be a fact table load this data into QVW and using binary load concept and load it into another QVW and build data model from there.

source:@vinay Bangari

3)Pivot table is special to group dimensions, there is no fixed option for that.

hope u get answered well .

Regards

Pavan