1)rendering extensions in ssrs?
2)typical scenario u hav faced?
3)drilldown and drillthrough?
4)asynchronous and synchronous transformations?
5)examples of synchronous and asynchronous transformations? done
6)join and union difference?
7)joins types used in database development?
8)what type of reports u have created?
9)do you use any tools apart from ssis,ssrs and ssas?
10)type 1 and type 2 dimensions?
11)what is datawarehouse?
12)do you use datawarehouse or database?
13)do you work on rolebased security and level in that?
14)what is primarykey?
15)what is difference b/w join and union?
16)diff b/w truncate and delete?
17)how to do the logging in ssis?
18)how to optimize the performance of ssis packages?
19)difference b/w lookup and fuzzy lookup?
20)how to store the eventinfo of ssis pkg into sql server?
21)do u involved in optimizing the sql queries?
22)when iam loading the data from flat file source what
should i consider?
23)what is the taskhost container?
24)does it in the controlflow?
25)how to setup a connectionstring dynamically?
26)what is the union operator?
27)what is the variable used for connectionstring?
28)what is lookup transformation?
29)what are ddl commands?
30)what is correlated subquery?
31)what is the partitioned view?
32)do you work on subscriptions in ssrs?
33)can we use where with truncate?
34)howmany buffers used in a transformation?
35)did you involve in any document design?
36)what are the limitations of ssrs?
37)what type of reports u have created?
38)who is your client?
39)why should you go for drilldown and drillthrough reports in which situation you used it?
2)typical scenario u hav faced?
3)drilldown and drillthrough?
4)asynchronous and synchronous transformations?
5)examples of synchronous and asynchronous transformations? done
6)join and union difference?
7)joins types used in database development?
8)what type of reports u have created?
9)do you use any tools apart from ssis,ssrs and ssas?
10)type 1 and type 2 dimensions?
11)what is datawarehouse?
12)do you use datawarehouse or database?
13)do you work on rolebased security and level in that?
14)what is primarykey?
15)what is difference b/w join and union?
16)diff b/w truncate and delete?
17)how to do the logging in ssis?
18)how to optimize the performance of ssis packages?
19)difference b/w lookup and fuzzy lookup?
20)how to store the eventinfo of ssis pkg into sql server?
21)do u involved in optimizing the sql queries?
22)when iam loading the data from flat file source what
should i consider?
23)what is the taskhost container?
24)does it in the controlflow?
25)how to setup a connectionstring dynamically?
26)what is the union operator?
27)what is the variable used for connectionstring?
28)what is lookup transformation?
29)what are ddl commands?
30)what is correlated subquery?
31)what is the partitioned view?
32)do you work on subscriptions in ssrs?
33)can we use where with truncate?
34)howmany buffers used in a transformation?
35)did you involve in any document design?
36)what are the limitations of ssrs?
37)what type of reports u have created?
38)who is your client?
39)why should you go for drilldown and drillthrough reports in which situation you used it?
No comments:
Post a Comment