SSIS
1. Check Point File Extension? Ans : .XML
2. Do you have participated in jobs creation . Then how to schedule the job , then how to send the mail to the client?
3. What type of sources getting from your client?
4. How to configure the packages and what type of configuration files used in your packages to which purpose you use it?
5. In SSIS diff bw Join and MergeJoin?
6. How to eliminate the Duplicate rows in SSIS packages?
7. Do you have participated in SCDs ? which type of SCD used in your project?
8. What are the SSIS Components?
9. What is use of configuration file in SSIS?
10. Wt are the joins used in SSIS packages?
11. Architecture changes in 2012?
12. Transactions and Event Handling?
13. Logging and how to create logging?
14. How you create Caches in SSIS Package?
15. Wt is script task and wt language is used in your script task?
16. Diff bw control flow and dataflow?
17. How you used check points in your SSIS Package and wt are the advantages of Check Points?
18. Diff bw Union and Join?
19. Wt are the activities in SSIS Package?
20. How to delete values from tables using SSIS packages? When table is unknown then how to delete a table using SSIS?
21. To load a 15000 records from Excel sheet to DataBase using Direct Loading?
Ans: to use Bulk Insert
For day to day insert to use INCREMENTAL Loading
22. How to configure Excel file?
23. Wt is Configuration file ? How we use in SSIS Package?
24. How to connect Package1 to Package2 using Variables?
25. How to Debugging a package and tell me different types ?
26. How to use Configuration files in SSIS?
27. HOW TO CONNECT OTHER DATABASE
28. SEMI-BLOKING T/F
29. DIFFERENCE B/W OLEDB AND SQLSERVERDESTINATIO
30. SYNCHRONOUS TRANSFORMATION
31. DIFFERENCE B/W SQLSERVER 2005 &2008
32. D/F B/W DTS AND SSIS
33. Difference bw Check Points & Break Points?
34. How many ways we can deploy the SSIS Packages?
35. How to create a package without using DFT Task?
36. Diff bw UnionALL & MergeJoin?
37. Diff bw LookUp & Fuzzy LookUp?
38. Wt is ERROR Handling?
39. What are the challenging situations you are faced in SSIS?
40. IN MY SOURCE .TXT,.CSV,EXCEL FILES ARE THERE HOW CAN YOU LOADE IN TO ONE DATABASE
41. HOW TO MOVE ONE DATABASE TO ANOTHER DATABASE WITH ALL BASE OBJECT
42.
43. HOW DO YOU RUN 3 TASK PARALLE
44. Wt type of info provided in Progress Tab?
45. Briefly explain about SCDs in SSIS?
46. Wt is DT_STR , DT_WSTR?
47. Wt type of files getting from client & getting to load Data Base?
48. How to configure a Flat File properties in SSIS Package?
49. Wt type of Testing you are using in your project?
50. Can you move set of files to destination , if possible which task you use?
51. Can we use Execute SQL Task params in another task/not?
52. SCD – Business Key, Changing attribute Key
53. Derieved Column?
54. Can we put 3-pages PDF data into a Single page?
55. Do you created any DTS Packages?
56. Tell me Control Flow Tasks?
57. Wt is Aggregation?
58. How to configure XML, Excel Files in SSIS?
59. Types of Row_By_Row transaction tasks?
60. Types of Variables?
61. Transaction Types?
62. OLEDB: Object Linking Embedded DataBase
63. How to Use For Loop & For Each Loop containers in Real Time?
64. Types of Control Flow Tasks?
65. Are you used parameters in any SSIS package?
parameters are the replacement for configurations that are in the current version of SSIS (i.e. SSIS2008).
There are two types of parameters:
• Project parameters
• Package parameters
We can see these in Expression Builder.
66. What is a conditional split?
67. precidence constraint?
68. SCD Type2,Manual SCD?
69. Difference between FORLOOP and FOREACHLOOP?
70. Wt are the Tasks you used in your Project?
71. Wt is Transformation & Why we use Transformation?
To perform intermediate Operations.
72. Where you write SQL Queries in your SSIS Package?
73. List of Some Transformations?
74. OLEDB Source,OLEDB Destination, Connection all are correct but data not moved to destination . Why?
Wt is the problem?
75. Containers in Control Flow?
76. If any Bugs are happened how you Debug it / wt can we do?
77. Wt are the Errors we find in Real Time?
78. How can we get the data from the Clients?
79. Wt is Row Data ? how can you get that?
80. How SCD is helped in your project?
81. Scenario:
Update 1-table in one server & insert values into one table in another server. Which task we use in SSIS.
Ans: Except “Execute SQL Task” any other answer.
82. how use execute sql task in ssis package
83. how to call child package from parent package using a variable
You can pass information from a parent package to a child via a Parent Package Variable Configuration.
On both packages we will create a string variable named "strVar"
parent package variable value is “parent”
and same as “child” in Child package.
Now
In parent pkg drag & Drop the EXECUTE SQL Task and point it to the location of Child Package
Now
In Child pkg , RC on ControlFlow Task & Select Pkg Configurations click on ADD then select config menu as “Parent pack Variable” and in the Parent Variable field give “StrVar”(Parent VarName) Next
now click on “Object” pane (leftside) now select the VarName of “StrVar” (+) and then select “Value” tab(means we copying the parent variable) Finish.
Now
We can verify value by Script task. By executing we we will get Parent value, and if you want to get child value alone you need to run child pack alone.
84. when u create log file using sql server log file in which data base table it store
85. what is use of SSIS configurations
86. what are the isolation levels in SSIS, How it is usefull for package executions
87. what is bridge table
88. How to use configuration files in ssis
89. How to provide a security for packages
90. how to execute packages with out using the the dataflow task
91. HOW TO CONFIGURE THE EXCEL FILE
10)
ID
1
2
3
4
5
6
7
8
9
10
I WANT BOTTOM 2 NUMBERS WITH OUT USING WHERECLAUSE
92. WHAT IS MAGIC TABLES
93.
ID
1
1
1
1
2
2
2
3
3
3
4
4
4
4
4
4
4
I WANT OUTPUT LIKE THIS
1-4
2-3
3-3
4-7
94. IN THE ABOVE TABLE I WANT OUTPUT
3-3
4-7
95.
SSRS
1. How can we create Reports through Excel_sheets?
2. Have you created reports from cube?
3. How can U create a Report from Procedure?
4. Wt is Report Publishing/deploying? And its process/navigation (OR)
How many ways we deploy the Reports in SSRS? Tell me about , Syntax for Command Line Deployment?
5. Display Alternative Color to alternative Rows?
6. Using 2-DataSets how to create a Single Table/Report?
Ans: no we can’t.
7. 2-DataSets using Report?
8. How to pass multi-valued parameter to stored procedure in dataset?
9. Variables & Parameters, Diff?
10. Diff bw parameters & Filters?
Filters occur after the data is downloaded.
Query parameters are executed at the server and only that data is returned.
11. Reporting Life Cycle?
12. Wt are the new features available in 2005, 08, 08R2,12 reporting services?
13. Architecture changes in 2012?
14. Diff bw List & Rectangle?
15. Wt type of Reports you created in your project?
16. Scripts?
17. Reports delivery, subscription?
18. Configuration files in RS?
The rs.config file defines the relay server farm, including peer relay servers, back-end server farms and their server nodes.
Sybase recommends that you generate the file in Sybase Control Center. Then, if there are additional changes you need to make, you can implement those manually.
• For IIS: C:\Inetpub\wwwroot\IAS_relay_server\Server\rs.config
• For Apache: <Apache_Home>/modules/rs.config
19. Is there is any possibility to taka a calendar date for a parameter value in a cascaded parameter as current date?
20. What is toggle item?
21. How many types of reports are created till now?(More than 50/60 is better I think)
22. Wt is ReportServerDataBase?
23. How do you provide the security to the Reports?
24. When you creating reports what are the complexity you faced?
25. Drill Down Reports?
26. Wt is Matrix Reports?
27. Diff bw Table & Matrix Reports?
28. Types of Reports, SET Operations?
29. Wt is Tablix Properties?
30. Tell about Parameterised reports?
31. Diff bw Queried & Cascaded Parameter Reports?
32. Types of Data Sources and Differences?
33. Tell about Linked Report?
34. Wt is Report Builder? Do you have used Report Builder?
35. Wt type of Reports created on Report Builder?
36. How many types of Data Sources used in your Report?
37. Wt is Linked Report ? how to create it.
38. Wt is Sub Report? And how to create it? How many Sub Reports you created?
39. Bar Code Reports, Excel sheet Barcode Reports
40. If you made changes in DSV it will affect physical table?
Ans: Yes , possible. “WriteBack” option is there in 2008R2
41. Can you create a Hierarchy
42. Types of Reports?
43. Types of Variables?
44. Can you use a stored procedure to provide data to an SSRS report?
Yes, you can use a stored procedure to provide data to an SSRS report by configuring the dataset to use a stored procedure command type. However, your stored procedure should return only a single result set. If it returns multiple result sets, only the first one is used for the report dataset.
45. CountRow / RowCount in SSRS?
46. Wt is Report Server ? wt are the Reports you created in your project?
47. Tell me about your Geo Spatio Report?
48. SQL Script or EQL Script?
49. Data Regions?
50. Filters types & Parameters Types?
DataSet Parameter: The purpose of a Dataset Parameter (aka Query Parameter) is to perform a filter within the source query. Report Parameter : The Report Parameter properties contain all of the settings related to a parameter (available values, default values, etc). A Report Parameter might or might not be associated to a Dataset Parameter. Unless it's hidden, the purpose of a Report Parameter is to interact with the user:
The vast majority of the time, a Report Parameter is associated to a Dataset Parameter – i.e., its purpose is to filter the data being displayed based on the user’s selection. However, if a Report Parameter is not bound to a Dataset Parameter, the Report Parameter could be used for all kinds of cool & creative things related to layout, formatting, or actions.
Report Filter. This includes filtering after the source query has come back – on a data region (like the Tablix), or a data grouping. When you implement a filter within the report, when the report is re-executed again with different parameter choices, the Report Server uses cached data rather than returning to the database server. This is a viable option if you intentionally want to return all possible data from the database server in the initial query. Keep in mind this could be far less performant if the volume of data is high & the report won’t be re-executed numerous times.
51. Diff bw Local & Glowbal Variables?
52. DIFF B/W ADHOC AND RANDAM REPORT
53. WHAT IS STANDARD REPORT
54. How do you reference an Embedded function in a Report?
55. Wt happens if you don’t specify parameter value in a SubScription? Here parameter doesn’t have default value?
56. Wt mechanism do you identify to Reduce the OverHead of DataSource?
57. Can you Edit RDL Code associated with a Linked Report?
58. How do you running aggregations in SSRS?
59. Report Parameter?
60. Wt is the Main purpose of Embedded Code in a Report?
61. Issues in creating a Report in Real Time?
62. Report Server, Report Manager, Diff?
63. Snap Shot,
64. Cascading Params,
65. Shared Data Source?
66. Through Wizard How many Reports you created?
67. Diff bw Drill Through & Sub Reports?
68. I provided entire requirements to you Then how to create reports > Steps?
69. Wt type of Queries used in your Report?
70. You want to create an Excel interactive report from SSRS. In SSRS, can you create the same interactive experience in Excel that you would have on the Web?
No, you cannot create the same experience with SSRS. you can, however, use Excel to create such an experience.
71. How do you configure a running aggregate in SSRS?
You can use the RunningValue function to configure a running aggregate.
72. What is the main purpose of a report parameter?
The main purpose of a report parameter is to add interactivity to your reports, letting users change the report behavior based on options they select.
73. behavior based on options they select.
74. What is the main purpose of a query parameter?
The main purpose of a query parameter is to filter data in the data source.
75. What is the main benefit of using embedded code in a report?
The main benefit of using embedded code in a report is that the code you write at the report level can be reused in any expression in the report.
76. What programming language would you use to create embedded functions in SSRS?
An SSRS report supports only visual Basic .nET embedded code.
77. WHICH TOOLU R USING IN THE REPORT PROJECT
SQL Server
1. How can we retrieve Alternative Rows from a table?
2. How can we do custom order on particular column?
3. Query process order: Select , order by, group by, where, from , top, having?
4. How can we select single max sal from no same max salaries?
5. How can we insert data into a table without create statement?
6. How to eliminate the Duplicate rows?
7. How to find top1 salaries in each department , the sal have the minimum of avgsal?
Select top 1 sal from EMP
Where sal>( Select avg(sal) from EMP
Where deptno=all (or) IN(10,20,30)
8. Wt is Index ? wt is Default index in a Table?
9. Give me a Scenario for the L.O.j?
10. PERFORMANCE TUNNING IN SQLSERVER
11. Diff bw SP and Function?
12. What is a text qualifier?
13. DIFFERENCE B/W SQLSERVER 2005 AND 2008
14. MERGE DATATYPE
15. WHAT IS THE REPORT SERVER DATABASE
16. HOW YOU PROVIDE A SECURITY FOR THE REPORT
17. Which joins you used in Real Time?
18. Which one gives better performance in SSIS or in T-SQL?
SSIS
19. SQL injection query service
Trigger
20. WRITE A QUEARY OF THE FIRST DAY OF THE MONTH
21. WHAT IS THE OUTPUT OF QUEARY SELECT * FROM EMP WHERE 1=0
22. WHAT IS THE OUTPUT OF QUEARY SELECT * FROM EMP WHERE 1=1
23. WHAT IS THE OUTPUT OF QUEARY SELECT * FROM EMP WHERE 1=NULL
24. WHAT IS THE OUTPUT OF QUEARY SELECT * FROM EMP WHERE NULL=NULL
25. WHICH ONE(TEMP TABLE AND TEMPTABLE VARIABLE) IS FASTEST
26. WRITE A QUEARY USING CTE TO GENERATE "HAI" TO THE BASE WORD
HAI
HAIA
HAIAA
HAIAAA
27. WRITE A UPDATE QUEARY UPDATE COLUMN AGE IN TABLE T1 FROM AGE COLUM IN T2(SINGLE QUEARY)
T1
NAME AGE
A 27
B 34
C 29
T2
NAME AGE
A 31
B 34
C 33
28.
29. Replication?
30. OPENROWSET?
31. Architecture changes in 2012?
32. .Can we use where clause in groupby clause?
33. define indexes, what is filtered index
34. can u create index on temp tables
35. difference between Rank & Dense Rank
36. tab1, tab2
Eno, sal eno, sal
111. 10000 111 3000
112. 45000 111 2000
123. 11000 111 1000
124. 12000 123 4000
Write query for tab 1 is emp sal, tab 2 is eno takes advance from his salary after deduction each emp sal to find current emp salaries?
37. difference between join and union?
38. table
eno, ename
101. xxxx
102. xxy
103. ccc
104. vvv
null ffff
null bbb
select count(eno) from table
select count(1) from table
select count(*) from table
select count(15) from table
39. what is query execution plan
40. LIST THE TYPES OF USER DEFINE FUNCTION IS SQLSERVER 2005
41. difference between stored procedure and triggers
42. ID FIRSTNAME MIDDLENAME LASTNAME
1 A NULL NULL
2 NULL B NULL
3 C NULL NULL
4 NULL NULL D
OUTPUT
ID NAME
1 A
2 B
3 C
4 D
WITHOUT USING NULLFUNCTION AND CASESTATEMENT
43. difference between cast and convert functions
44. difference between replace and stuff function, varchar and nvarchar
45. Diff bw Inner join and Left outer join?
46. Diff bw PK and UK?
47. Diff bw SUB Query and Corelated SubQuery?
48. Diff bw SQL Server 05/08?
49. Diff bw SQL Server 08/12?
50. Wt is Merge data type?
51. Diff bw Union and Join?
52. DIFFERENCR B/W STORED PROCEDURE AND FUNCTION AND PERFOMANCE WHICH IS BEST
53. What is the difference between global and temporary variable
54.
55. WRITE A SQLQUEARY TO CONCATENATE STRING VALUES SEPARATED BY COMMA FOR THE TABLE XYZ
NAME AGE
ROBET 45
GARY 54
ERIC 34
BOB 23
OUTPUT
ROBET,GARY,ERIC,BOB
56.
57. Diff bw Temporary Table & Temp Variable?
58. Types of joins?
59. Which are the Types of SQL Table Objects?
60. Wt are the different Index configurations a table can have?
61. Sub Queries 3-Types?
62. Wt is COALSCES()
63. what is RANK(),ROWNUMBER(),DENSERANK()
64.
65. Diff bw Inner & Outer Joins?
66. .column1 column2
1 1
1 1
1 1
1 1
join the above two tables as Inner and left join
column1 column2
1 1
2 2
3 3
4 4
null null
join the above two tables
67. what is covering index?
Creating a non-clustered index that contains all the columns used in a SQL query, a technique called index covering
I can only suppose that a covered query is a query that has an index that covers all the columns in its returned recordset. One caveat - the index and query would have to be built as to allow the SQL server to actually infer from the query that the index is useful.
For example, a join of a table on itself might not benefit from such an index (depending on the intelligence of the SQL query execution planner):
PersonID ParentID Name
1 NULL Abe
2 NULL Bob
3 1 Carl
4 2 Dave
Let's assume there's an index on PersonID,ParentID,Name - this would be a covering index for a query like:
SELECT PersonID, ParentID, Name FROM MyTable
But a query like this:
SELECT PersonID, Name FROM MyTable LEFT JOIN MyTable T ON T.PersonID=MyTable.ParentID
Probably wouldn't benifit so much, even though all of the columns are in the index. Why? Because you're not really telling it that you want to use the triple index of PersonID,ParentID,Name.
Instead, you're building a condition based on two columns - PersonID and ParentID (which leaves out Name) and then you're asking for all the records, with the columns PersonID, Name. Actually, depending on implementation, the index might help the latter part. But for the first part, you're better off having other indexes.
68. Wt is CTE? how it can be used in a table?
69. Diff bw TempTable and CTE?
70. Diff bw Union & UnionAll?
71. Wt is Index ? types of indexes , why we use only 1-clustered index in table. Default clustered index?
72. Wt is Synonym, index.
73. DIFFERENCE B/W STUFF AND REPLACE
74. WHAT IS PIVOTTABLE
75. HOW TO RESET THE IDENTITY COLUMN
76. WHAT ARE THE USRE DEFINED DATATYPES AND WHEN YOU SHOULD GO FOR THEM
77. WHAT IS BIT DATATYPE AND WHAT'S IS INFORMATION THAT CAN BE STORED INSIDE THE BIT COLUMN
78. LIMATION OF SELECT STATEMENT
79. WHAT TYPES OF LOCKING
80. WHAT IS THE INDXSEEK AND INDEX SCAN
81. Diff B/W LOGINS AND USER
82. Scenario: (CTS)
Eid ename Deptid
101 a 20
Salary
Eid sal
101 3000
Dept
Deptid dname location
20 Hr bang
21 it bang
22 sls hyd
Output:
Location total Salary total emps
-----------------------------------------------
Output:
Deptname
To find dname whose salaries are maximum of each dept wise
83. Wt is Temporary Table, how we use in the DataBase?
84. How to find duplicates in a Table?
85. Wt types of Functions available in SSMS?
86. Wt is Query Hint?
87. can we write delete on 3 tables
88. How to query performance increase using Stored Procedures?
89. Diff bw Truncate & Drop?
90. How many types of indexes in SSMS?
91. Wt is Self Referencing table in SQL Server?
92. Wt are the Dynamic Queries?
93. Wt is CTE?
94. What is the difference between SCRIPT task and script component
95. How can you rectify errors while executing a stored procedures?
96. What are the different index configurations a table can have?
97. Difference b/w Local Temporary and Global Temporary tables in SQL?
98. If we delete a table can we RollBack / not?
Ans: By Transactions we can do.
99. I just created one table without any key . wt type of Index created there?
100. Write a SP to insert value bw 10000 & 50000 only.
If we insert value bw the above the range print message like “Value not allow” otherwise print the value if it is in bw the Range?
101. Wt is constraint and its Types?
102. How can we get the List of User Tables?
103. Wt is Composite key?
104. Wt is IDENTITY?
105. Scenario:
eno ename mgrno
1 a 3
2 b 5
3 c 6
Query for Emp details whose eno & mgrno is Same?
106. Create table Syntax?
107. Update Command Syntax?
108. In a Data Base we have Five tables in that DB wt are the table(s) which have “Salary” column?
Ans: Select Sysob+”.”+TableName
From Information_schema.Column
where column=’Salary’
109. How to find which SP is executed on particular Table?
110. Syntax for Group By Operator?
111. column1 column2
ab"cd 20
"xyz" 30
How can you eliminate the symbol( ") in the above table and load in to the destination?
112. Which type of join will be formed, when you just specify two tables in from clause without writing any join condition between two tables?
113. Can a table have more than 1-PK/not?
Ans: A table has only 1-PK but a table columns have more than 1-PK.
114. Can a SP call another SP?
Ans: A SP can call 1/34 SPs or 1/34 functions But a Function can’t call SP.
Lly A function can call 34 Functions/1 function.
115. Write a Query to find the empname where salary is Max in that table?
116. Scenario:
Insert no from 1 to 1000 in a table?
Declare @i int
SET @i=1
While (@>=1000)
Begin
@i=@i+1
Insert into Table Values(@i)
End
117. Change Balu to Kalu by STUFF() Function?
Ans: Select STUFF(‘Balu’,1,B,’K’)
118. Diff bw WHERE & HAVING?
119. Types of Data Types?
120. Cursor types? And syntax?
121. Triggers , usage?
122. Stored Procedures, Usage?
123. Functions, Replication, Built in Functions?
124. Normalization & BOYCE Code Normalization?
125. Diff bw SUB Query & View?
126. Diff bw Corelated & Nested Sub Query?
127. Scenario:
Eno ename salary
101 krishna 3000
101 venkat 4000
103 kishore 2000
104 kiran 7000
Print the Avg of salary from the same eno.
128. Syntax for CONVERT() Function?
129. Index, which index is Faster?
130. Union & UnionAll diff?
Which is Faster, why?
131. Merge, MergeJoin, which is Faster, & Why?
132. Delete & Truncate commands which is Faster and Why?
133. Joins, Triggers,
134. Steps to Create Cursor?
135. Wt is Candidate Key, Magic Table?
136. Row Data?
137. 18th Highest Salary?
138. Index Syntax?
139. Diff bw SP & Function?
140. BOB Tech Q’s
ID NAME AGE SALARY
1 ANDY 61 140000
2 RACHEL 34 44000
5 CHRIS 34 40000
7 CHANDLER 41 52000
8 ROSS 57 115000
11 JOE 38 38000
THE ABOVE IS THE “SalesPerson” Table
Oreders Table is Below given:
Name Order_date Clientid Salespersionid Amount
10 8-2-96 4 2 540
20 1-30-99 4 8 1800
30 7-14-95 9 1 460
40 1-29-98 7 2 2400
50 2-3-98 6 7 600
60 3-2-98 6 7 720
70 5-6-98 9 7 150
60 3-2-98 6 7 720
Client Table:
Id Name City Industrytype
4 Pija Hut Banglore
6 Dominos Hyderabd
7 Papa Coat Chennai
9 popajohns Mumbai
Q’s:
141. Names of all salespersons who have an order with Dominos
142. Names of all SPs who donot have any order with dominos & popajohns
143. Names of SPs that have 2 or more orders worth $100
144. Write a SQL Trigger to insert rows into a table called HighAchiever(Name,Age) when a SP sales amount >5000
145. W.a.q to delete any duplicate rows from orders table
146. Name of the person who have not made any sales or sales<50 in each year
147. Every sale amount , date of sale with the total amount of sales for that day.
148.
SSAS
1. How to create the Dynamic Measure Group Partition from Partitioned Database Table in a SSAS.?
2. Display Actual Cost as ‘9999’ , if it is empty?
3. Diff bw set & Members.
4. Diff bw set & Calculated Members
5. Wt is Hierarchies and how to create it?
6. Wt are the ROLES in SSAS?
7. Wt is Named Set?
8. What is FAMSI
Fast Analysis of Shared Multidimensional Information
9. Wt is Measures, Calculated Measures, Derieved Measures?
10. Wt are the Dimensions used in your Project?
11. PARTITION AND NAMEDS SET
12. WRITE A QUEARY TO GET TOP 2 SALES USING MDX QUEARY
13. How many ways we can deploy SSAS Cubes?
14. WHAT IS DATA REGION
15. For analyzing the CUBE dimension values how many AS languages available ?
Ans: 4
MDX, XMLA, DMX
16. Wt is Partition in SSAS?
17. New Features in SSAS 05,08,08R2,12?
18. Can you create a hierarchy for attributes in a different Dimensions?
Ans: yes you can create dimension wise also.
19. Calculated Members, KPIs?
20. Wt is SSAS & Why we USE?
21. How will you provide a MANY-TO-MANY relation to a cube?
22. How did you get NOT NULL values while writing a MDX query?
23. Roles in SSAS project?
24. You want to use a perspective in an MDX query. How do you select the perspective?
Use the Cube Selector in the MDX Query Designer to select a perspective.
Others
1. Tell me About Ur Self?
2. Define DWH and briefly explain the 2- approaches?
3. What is Fact table? And its types?
4. Wt is Dim table , and its types?
5. How do you create a Sorragate key and explain?
6. Types of schemas and wt type of schema you used in your project?
7. Star schema and snowflake schema which is better?
8. Wt is Junk Dimension and what type of data it contains?
9. Wt are the Dimensions used in your Project?
10. Types of OLAP? And wt type of OLAP used in your Project?(HOLAP, MOLAP, ROLAP,DOLAP)
11. Tell me about the schemas? Wt type of schema you used in your project . why use snowflake schema?
12. Wt is Data Model & DWH?
13. Why the DWH is called as Historical DWH?
14. Wt is Sorrogate Key?
15. Wt is Hierarchy ? N how to create it?
16. Which data model your project is following?
17. How do you test unit test cases in your current project?
18. Tell me the project architecture?
19. Tell me ETL process of your project?
SQL Server:
1. How to find a column existence in a Database of SQL server?
2.
Ans’s:
SQL Server:
1.How to find a column existancy in SQL Server?
SELECT c.name AS ColName, t.name AS TableName
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%MyName%'
Or
USE AdventureWorks
GO
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%EmployeeID%'
ORDER BY schema_name, table_name;
Or
SELECT distinct(TABLE_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%EmployeeID%'
(The above is for Including Views)
Or
SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name like '%EmployeeID%' )
(Note: Including Stored Procedures also)
1. Check Point File Extension? Ans : .XML
2. Do you have participated in jobs creation . Then how to schedule the job , then how to send the mail to the client?
3. What type of sources getting from your client?
4. How to configure the packages and what type of configuration files used in your packages to which purpose you use it?
5. In SSIS diff bw Join and MergeJoin?
6. How to eliminate the Duplicate rows in SSIS packages?
7. Do you have participated in SCDs ? which type of SCD used in your project?
8. What are the SSIS Components?
9. What is use of configuration file in SSIS?
10. Wt are the joins used in SSIS packages?
11. Architecture changes in 2012?
12. Transactions and Event Handling?
13. Logging and how to create logging?
14. How you create Caches in SSIS Package?
15. Wt is script task and wt language is used in your script task?
16. Diff bw control flow and dataflow?
17. How you used check points in your SSIS Package and wt are the advantages of Check Points?
18. Diff bw Union and Join?
19. Wt are the activities in SSIS Package?
20. How to delete values from tables using SSIS packages? When table is unknown then how to delete a table using SSIS?
21. To load a 15000 records from Excel sheet to DataBase using Direct Loading?
Ans: to use Bulk Insert
For day to day insert to use INCREMENTAL Loading
22. How to configure Excel file?
23. Wt is Configuration file ? How we use in SSIS Package?
24. How to connect Package1 to Package2 using Variables?
25. How to Debugging a package and tell me different types ?
26. How to use Configuration files in SSIS?
27. HOW TO CONNECT OTHER DATABASE
28. SEMI-BLOKING T/F
29. DIFFERENCE B/W OLEDB AND SQLSERVERDESTINATIO
30. SYNCHRONOUS TRANSFORMATION
31. DIFFERENCE B/W SQLSERVER 2005 &2008
32. D/F B/W DTS AND SSIS
33. Difference bw Check Points & Break Points?
34. How many ways we can deploy the SSIS Packages?
35. How to create a package without using DFT Task?
36. Diff bw UnionALL & MergeJoin?
37. Diff bw LookUp & Fuzzy LookUp?
38. Wt is ERROR Handling?
39. What are the challenging situations you are faced in SSIS?
40. IN MY SOURCE .TXT,.CSV,EXCEL FILES ARE THERE HOW CAN YOU LOADE IN TO ONE DATABASE
41. HOW TO MOVE ONE DATABASE TO ANOTHER DATABASE WITH ALL BASE OBJECT
42.
43. HOW DO YOU RUN 3 TASK PARALLE
44. Wt type of info provided in Progress Tab?
45. Briefly explain about SCDs in SSIS?
46. Wt is DT_STR , DT_WSTR?
47. Wt type of files getting from client & getting to load Data Base?
48. How to configure a Flat File properties in SSIS Package?
49. Wt type of Testing you are using in your project?
50. Can you move set of files to destination , if possible which task you use?
51. Can we use Execute SQL Task params in another task/not?
52. SCD – Business Key, Changing attribute Key
53. Derieved Column?
54. Can we put 3-pages PDF data into a Single page?
55. Do you created any DTS Packages?
56. Tell me Control Flow Tasks?
57. Wt is Aggregation?
58. How to configure XML, Excel Files in SSIS?
59. Types of Row_By_Row transaction tasks?
60. Types of Variables?
61. Transaction Types?
62. OLEDB: Object Linking Embedded DataBase
63. How to Use For Loop & For Each Loop containers in Real Time?
64. Types of Control Flow Tasks?
65. Are you used parameters in any SSIS package?
parameters are the replacement for configurations that are in the current version of SSIS (i.e. SSIS2008).
There are two types of parameters:
• Project parameters
• Package parameters
We can see these in Expression Builder.
66. What is a conditional split?
67. precidence constraint?
68. SCD Type2,Manual SCD?
69. Difference between FORLOOP and FOREACHLOOP?
70. Wt are the Tasks you used in your Project?
71. Wt is Transformation & Why we use Transformation?
To perform intermediate Operations.
72. Where you write SQL Queries in your SSIS Package?
73. List of Some Transformations?
74. OLEDB Source,OLEDB Destination, Connection all are correct but data not moved to destination . Why?
Wt is the problem?
75. Containers in Control Flow?
76. If any Bugs are happened how you Debug it / wt can we do?
77. Wt are the Errors we find in Real Time?
78. How can we get the data from the Clients?
79. Wt is Row Data ? how can you get that?
80. How SCD is helped in your project?
81. Scenario:
Update 1-table in one server & insert values into one table in another server. Which task we use in SSIS.
Ans: Except “Execute SQL Task” any other answer.
82. how use execute sql task in ssis package
83. how to call child package from parent package using a variable
You can pass information from a parent package to a child via a Parent Package Variable Configuration.
On both packages we will create a string variable named "strVar"
parent package variable value is “parent”
and same as “child” in Child package.
Now
In parent pkg drag & Drop the EXECUTE SQL Task and point it to the location of Child Package
Now
In Child pkg , RC on ControlFlow Task & Select Pkg Configurations click on ADD then select config menu as “Parent pack Variable” and in the Parent Variable field give “StrVar”(Parent VarName) Next
now click on “Object” pane (leftside) now select the VarName of “StrVar” (+) and then select “Value” tab(means we copying the parent variable) Finish.
Now
We can verify value by Script task. By executing we we will get Parent value, and if you want to get child value alone you need to run child pack alone.
84. when u create log file using sql server log file in which data base table it store
85. what is use of SSIS configurations
86. what are the isolation levels in SSIS, How it is usefull for package executions
87. what is bridge table
88. How to use configuration files in ssis
89. How to provide a security for packages
90. how to execute packages with out using the the dataflow task
91. HOW TO CONFIGURE THE EXCEL FILE
10)
ID
1
2
3
4
5
6
7
8
9
10
I WANT BOTTOM 2 NUMBERS WITH OUT USING WHERECLAUSE
92. WHAT IS MAGIC TABLES
93.
ID
1
1
1
1
2
2
2
3
3
3
4
4
4
4
4
4
4
I WANT OUTPUT LIKE THIS
1-4
2-3
3-3
4-7
94. IN THE ABOVE TABLE I WANT OUTPUT
3-3
4-7
95.
SSRS
1. How can we create Reports through Excel_sheets?
2. Have you created reports from cube?
3. How can U create a Report from Procedure?
4. Wt is Report Publishing/deploying? And its process/navigation (OR)
How many ways we deploy the Reports in SSRS? Tell me about , Syntax for Command Line Deployment?
5. Display Alternative Color to alternative Rows?
6. Using 2-DataSets how to create a Single Table/Report?
Ans: no we can’t.
7. 2-DataSets using Report?
8. How to pass multi-valued parameter to stored procedure in dataset?
9. Variables & Parameters, Diff?
10. Diff bw parameters & Filters?
Filters occur after the data is downloaded.
Query parameters are executed at the server and only that data is returned.
11. Reporting Life Cycle?
12. Wt are the new features available in 2005, 08, 08R2,12 reporting services?
13. Architecture changes in 2012?
14. Diff bw List & Rectangle?
15. Wt type of Reports you created in your project?
16. Scripts?
17. Reports delivery, subscription?
18. Configuration files in RS?
The rs.config file defines the relay server farm, including peer relay servers, back-end server farms and their server nodes.
Sybase recommends that you generate the file in Sybase Control Center. Then, if there are additional changes you need to make, you can implement those manually.
• For IIS: C:\Inetpub\wwwroot\IAS_relay_server\Server\rs.config
• For Apache: <Apache_Home>/modules/rs.config
19. Is there is any possibility to taka a calendar date for a parameter value in a cascaded parameter as current date?
20. What is toggle item?
21. How many types of reports are created till now?(More than 50/60 is better I think)
22. Wt is ReportServerDataBase?
23. How do you provide the security to the Reports?
24. When you creating reports what are the complexity you faced?
25. Drill Down Reports?
26. Wt is Matrix Reports?
27. Diff bw Table & Matrix Reports?
28. Types of Reports, SET Operations?
29. Wt is Tablix Properties?
30. Tell about Parameterised reports?
31. Diff bw Queried & Cascaded Parameter Reports?
32. Types of Data Sources and Differences?
33. Tell about Linked Report?
34. Wt is Report Builder? Do you have used Report Builder?
35. Wt type of Reports created on Report Builder?
36. How many types of Data Sources used in your Report?
37. Wt is Linked Report ? how to create it.
38. Wt is Sub Report? And how to create it? How many Sub Reports you created?
39. Bar Code Reports, Excel sheet Barcode Reports
40. If you made changes in DSV it will affect physical table?
Ans: Yes , possible. “WriteBack” option is there in 2008R2
41. Can you create a Hierarchy
42. Types of Reports?
43. Types of Variables?
44. Can you use a stored procedure to provide data to an SSRS report?
Yes, you can use a stored procedure to provide data to an SSRS report by configuring the dataset to use a stored procedure command type. However, your stored procedure should return only a single result set. If it returns multiple result sets, only the first one is used for the report dataset.
45. CountRow / RowCount in SSRS?
46. Wt is Report Server ? wt are the Reports you created in your project?
47. Tell me about your Geo Spatio Report?
48. SQL Script or EQL Script?
49. Data Regions?
50. Filters types & Parameters Types?
DataSet Parameter: The purpose of a Dataset Parameter (aka Query Parameter) is to perform a filter within the source query. Report Parameter : The Report Parameter properties contain all of the settings related to a parameter (available values, default values, etc). A Report Parameter might or might not be associated to a Dataset Parameter. Unless it's hidden, the purpose of a Report Parameter is to interact with the user:
The vast majority of the time, a Report Parameter is associated to a Dataset Parameter – i.e., its purpose is to filter the data being displayed based on the user’s selection. However, if a Report Parameter is not bound to a Dataset Parameter, the Report Parameter could be used for all kinds of cool & creative things related to layout, formatting, or actions.
Report Filter. This includes filtering after the source query has come back – on a data region (like the Tablix), or a data grouping. When you implement a filter within the report, when the report is re-executed again with different parameter choices, the Report Server uses cached data rather than returning to the database server. This is a viable option if you intentionally want to return all possible data from the database server in the initial query. Keep in mind this could be far less performant if the volume of data is high & the report won’t be re-executed numerous times.
51. Diff bw Local & Glowbal Variables?
52. DIFF B/W ADHOC AND RANDAM REPORT
53. WHAT IS STANDARD REPORT
54. How do you reference an Embedded function in a Report?
55. Wt happens if you don’t specify parameter value in a SubScription? Here parameter doesn’t have default value?
56. Wt mechanism do you identify to Reduce the OverHead of DataSource?
57. Can you Edit RDL Code associated with a Linked Report?
58. How do you running aggregations in SSRS?
59. Report Parameter?
60. Wt is the Main purpose of Embedded Code in a Report?
61. Issues in creating a Report in Real Time?
62. Report Server, Report Manager, Diff?
63. Snap Shot,
64. Cascading Params,
65. Shared Data Source?
66. Through Wizard How many Reports you created?
67. Diff bw Drill Through & Sub Reports?
68. I provided entire requirements to you Then how to create reports > Steps?
69. Wt type of Queries used in your Report?
70. You want to create an Excel interactive report from SSRS. In SSRS, can you create the same interactive experience in Excel that you would have on the Web?
No, you cannot create the same experience with SSRS. you can, however, use Excel to create such an experience.
71. How do you configure a running aggregate in SSRS?
You can use the RunningValue function to configure a running aggregate.
72. What is the main purpose of a report parameter?
The main purpose of a report parameter is to add interactivity to your reports, letting users change the report behavior based on options they select.
73. behavior based on options they select.
74. What is the main purpose of a query parameter?
The main purpose of a query parameter is to filter data in the data source.
75. What is the main benefit of using embedded code in a report?
The main benefit of using embedded code in a report is that the code you write at the report level can be reused in any expression in the report.
76. What programming language would you use to create embedded functions in SSRS?
An SSRS report supports only visual Basic .nET embedded code.
77. WHICH TOOLU R USING IN THE REPORT PROJECT
SQL Server
1. How can we retrieve Alternative Rows from a table?
2. How can we do custom order on particular column?
3. Query process order: Select , order by, group by, where, from , top, having?
4. How can we select single max sal from no same max salaries?
5. How can we insert data into a table without create statement?
6. How to eliminate the Duplicate rows?
7. How to find top1 salaries in each department , the sal have the minimum of avgsal?
Select top 1 sal from EMP
Where sal>( Select avg(sal) from EMP
Where deptno=all (or) IN(10,20,30)
8. Wt is Index ? wt is Default index in a Table?
9. Give me a Scenario for the L.O.j?
10. PERFORMANCE TUNNING IN SQLSERVER
11. Diff bw SP and Function?
12. What is a text qualifier?
13. DIFFERENCE B/W SQLSERVER 2005 AND 2008
14. MERGE DATATYPE
15. WHAT IS THE REPORT SERVER DATABASE
16. HOW YOU PROVIDE A SECURITY FOR THE REPORT
17. Which joins you used in Real Time?
18. Which one gives better performance in SSIS or in T-SQL?
SSIS
19. SQL injection query service
Trigger
20. WRITE A QUEARY OF THE FIRST DAY OF THE MONTH
21. WHAT IS THE OUTPUT OF QUEARY SELECT * FROM EMP WHERE 1=0
22. WHAT IS THE OUTPUT OF QUEARY SELECT * FROM EMP WHERE 1=1
23. WHAT IS THE OUTPUT OF QUEARY SELECT * FROM EMP WHERE 1=NULL
24. WHAT IS THE OUTPUT OF QUEARY SELECT * FROM EMP WHERE NULL=NULL
25. WHICH ONE(TEMP TABLE AND TEMPTABLE VARIABLE) IS FASTEST
26. WRITE A QUEARY USING CTE TO GENERATE "HAI" TO THE BASE WORD
HAI
HAIA
HAIAA
HAIAAA
27. WRITE A UPDATE QUEARY UPDATE COLUMN AGE IN TABLE T1 FROM AGE COLUM IN T2(SINGLE QUEARY)
T1
NAME AGE
A 27
B 34
C 29
T2
NAME AGE
A 31
B 34
C 33
28.
29. Replication?
30. OPENROWSET?
31. Architecture changes in 2012?
32. .Can we use where clause in groupby clause?
33. define indexes, what is filtered index
34. can u create index on temp tables
35. difference between Rank & Dense Rank
36. tab1, tab2
Eno, sal eno, sal
111. 10000 111 3000
112. 45000 111 2000
123. 11000 111 1000
124. 12000 123 4000
Write query for tab 1 is emp sal, tab 2 is eno takes advance from his salary after deduction each emp sal to find current emp salaries?
37. difference between join and union?
38. table
eno, ename
101. xxxx
102. xxy
103. ccc
104. vvv
null ffff
null bbb
select count(eno) from table
select count(1) from table
select count(*) from table
select count(15) from table
39. what is query execution plan
40. LIST THE TYPES OF USER DEFINE FUNCTION IS SQLSERVER 2005
41. difference between stored procedure and triggers
42. ID FIRSTNAME MIDDLENAME LASTNAME
1 A NULL NULL
2 NULL B NULL
3 C NULL NULL
4 NULL NULL D
OUTPUT
ID NAME
1 A
2 B
3 C
4 D
WITHOUT USING NULLFUNCTION AND CASESTATEMENT
43. difference between cast and convert functions
44. difference between replace and stuff function, varchar and nvarchar
45. Diff bw Inner join and Left outer join?
46. Diff bw PK and UK?
47. Diff bw SUB Query and Corelated SubQuery?
48. Diff bw SQL Server 05/08?
49. Diff bw SQL Server 08/12?
50. Wt is Merge data type?
51. Diff bw Union and Join?
52. DIFFERENCR B/W STORED PROCEDURE AND FUNCTION AND PERFOMANCE WHICH IS BEST
53. What is the difference between global and temporary variable
54.
55. WRITE A SQLQUEARY TO CONCATENATE STRING VALUES SEPARATED BY COMMA FOR THE TABLE XYZ
NAME AGE
ROBET 45
GARY 54
ERIC 34
BOB 23
OUTPUT
ROBET,GARY,ERIC,BOB
56.
57. Diff bw Temporary Table & Temp Variable?
58. Types of joins?
59. Which are the Types of SQL Table Objects?
60. Wt are the different Index configurations a table can have?
61. Sub Queries 3-Types?
62. Wt is COALSCES()
63. what is RANK(),ROWNUMBER(),DENSERANK()
64.
65. Diff bw Inner & Outer Joins?
66. .column1 column2
1 1
1 1
1 1
1 1
join the above two tables as Inner and left join
column1 column2
1 1
2 2
3 3
4 4
null null
join the above two tables
67. what is covering index?
Creating a non-clustered index that contains all the columns used in a SQL query, a technique called index covering
I can only suppose that a covered query is a query that has an index that covers all the columns in its returned recordset. One caveat - the index and query would have to be built as to allow the SQL server to actually infer from the query that the index is useful.
For example, a join of a table on itself might not benefit from such an index (depending on the intelligence of the SQL query execution planner):
PersonID ParentID Name
1 NULL Abe
2 NULL Bob
3 1 Carl
4 2 Dave
Let's assume there's an index on PersonID,ParentID,Name - this would be a covering index for a query like:
SELECT PersonID, ParentID, Name FROM MyTable
But a query like this:
SELECT PersonID, Name FROM MyTable LEFT JOIN MyTable T ON T.PersonID=MyTable.ParentID
Probably wouldn't benifit so much, even though all of the columns are in the index. Why? Because you're not really telling it that you want to use the triple index of PersonID,ParentID,Name.
Instead, you're building a condition based on two columns - PersonID and ParentID (which leaves out Name) and then you're asking for all the records, with the columns PersonID, Name. Actually, depending on implementation, the index might help the latter part. But for the first part, you're better off having other indexes.
68. Wt is CTE? how it can be used in a table?
69. Diff bw TempTable and CTE?
70. Diff bw Union & UnionAll?
71. Wt is Index ? types of indexes , why we use only 1-clustered index in table. Default clustered index?
72. Wt is Synonym, index.
73. DIFFERENCE B/W STUFF AND REPLACE
74. WHAT IS PIVOTTABLE
75. HOW TO RESET THE IDENTITY COLUMN
76. WHAT ARE THE USRE DEFINED DATATYPES AND WHEN YOU SHOULD GO FOR THEM
77. WHAT IS BIT DATATYPE AND WHAT'S IS INFORMATION THAT CAN BE STORED INSIDE THE BIT COLUMN
78. LIMATION OF SELECT STATEMENT
79. WHAT TYPES OF LOCKING
80. WHAT IS THE INDXSEEK AND INDEX SCAN
81. Diff B/W LOGINS AND USER
82. Scenario: (CTS)
Eid ename Deptid
101 a 20
Salary
Eid sal
101 3000
Dept
Deptid dname location
20 Hr bang
21 it bang
22 sls hyd
Output:
Location total Salary total emps
-----------------------------------------------
Output:
Deptname
To find dname whose salaries are maximum of each dept wise
83. Wt is Temporary Table, how we use in the DataBase?
84. How to find duplicates in a Table?
85. Wt types of Functions available in SSMS?
86. Wt is Query Hint?
87. can we write delete on 3 tables
88. How to query performance increase using Stored Procedures?
89. Diff bw Truncate & Drop?
90. How many types of indexes in SSMS?
91. Wt is Self Referencing table in SQL Server?
92. Wt are the Dynamic Queries?
93. Wt is CTE?
94. What is the difference between SCRIPT task and script component
95. How can you rectify errors while executing a stored procedures?
96. What are the different index configurations a table can have?
97. Difference b/w Local Temporary and Global Temporary tables in SQL?
98. If we delete a table can we RollBack / not?
Ans: By Transactions we can do.
99. I just created one table without any key . wt type of Index created there?
100. Write a SP to insert value bw 10000 & 50000 only.
If we insert value bw the above the range print message like “Value not allow” otherwise print the value if it is in bw the Range?
101. Wt is constraint and its Types?
102. How can we get the List of User Tables?
103. Wt is Composite key?
104. Wt is IDENTITY?
105. Scenario:
eno ename mgrno
1 a 3
2 b 5
3 c 6
Query for Emp details whose eno & mgrno is Same?
106. Create table Syntax?
107. Update Command Syntax?
108. In a Data Base we have Five tables in that DB wt are the table(s) which have “Salary” column?
Ans: Select Sysob+”.”+TableName
From Information_schema.Column
where column=’Salary’
109. How to find which SP is executed on particular Table?
110. Syntax for Group By Operator?
111. column1 column2
ab"cd 20
"xyz" 30
How can you eliminate the symbol( ") in the above table and load in to the destination?
112. Which type of join will be formed, when you just specify two tables in from clause without writing any join condition between two tables?
113. Can a table have more than 1-PK/not?
Ans: A table has only 1-PK but a table columns have more than 1-PK.
114. Can a SP call another SP?
Ans: A SP can call 1/34 SPs or 1/34 functions But a Function can’t call SP.
Lly A function can call 34 Functions/1 function.
115. Write a Query to find the empname where salary is Max in that table?
116. Scenario:
Insert no from 1 to 1000 in a table?
Declare @i int
SET @i=1
While (@>=1000)
Begin
@i=@i+1
Insert into Table Values(@i)
End
117. Change Balu to Kalu by STUFF() Function?
Ans: Select STUFF(‘Balu’,1,B,’K’)
118. Diff bw WHERE & HAVING?
119. Types of Data Types?
120. Cursor types? And syntax?
121. Triggers , usage?
122. Stored Procedures, Usage?
123. Functions, Replication, Built in Functions?
124. Normalization & BOYCE Code Normalization?
125. Diff bw SUB Query & View?
126. Diff bw Corelated & Nested Sub Query?
127. Scenario:
Eno ename salary
101 krishna 3000
101 venkat 4000
103 kishore 2000
104 kiran 7000
Print the Avg of salary from the same eno.
128. Syntax for CONVERT() Function?
129. Index, which index is Faster?
130. Union & UnionAll diff?
Which is Faster, why?
131. Merge, MergeJoin, which is Faster, & Why?
132. Delete & Truncate commands which is Faster and Why?
133. Joins, Triggers,
134. Steps to Create Cursor?
135. Wt is Candidate Key, Magic Table?
136. Row Data?
137. 18th Highest Salary?
138. Index Syntax?
139. Diff bw SP & Function?
140. BOB Tech Q’s
ID NAME AGE SALARY
1 ANDY 61 140000
2 RACHEL 34 44000
5 CHRIS 34 40000
7 CHANDLER 41 52000
8 ROSS 57 115000
11 JOE 38 38000
THE ABOVE IS THE “SalesPerson” Table
Oreders Table is Below given:
Name Order_date Clientid Salespersionid Amount
10 8-2-96 4 2 540
20 1-30-99 4 8 1800
30 7-14-95 9 1 460
40 1-29-98 7 2 2400
50 2-3-98 6 7 600
60 3-2-98 6 7 720
70 5-6-98 9 7 150
60 3-2-98 6 7 720
Client Table:
Id Name City Industrytype
4 Pija Hut Banglore
6 Dominos Hyderabd
7 Papa Coat Chennai
9 popajohns Mumbai
Q’s:
141. Names of all salespersons who have an order with Dominos
142. Names of all SPs who donot have any order with dominos & popajohns
143. Names of SPs that have 2 or more orders worth $100
144. Write a SQL Trigger to insert rows into a table called HighAchiever(Name,Age) when a SP sales amount >5000
145. W.a.q to delete any duplicate rows from orders table
146. Name of the person who have not made any sales or sales<50 in each year
147. Every sale amount , date of sale with the total amount of sales for that day.
148.
SSAS
1. How to create the Dynamic Measure Group Partition from Partitioned Database Table in a SSAS.?
2. Display Actual Cost as ‘9999’ , if it is empty?
3. Diff bw set & Members.
4. Diff bw set & Calculated Members
5. Wt is Hierarchies and how to create it?
6. Wt are the ROLES in SSAS?
7. Wt is Named Set?
8. What is FAMSI
Fast Analysis of Shared Multidimensional Information
9. Wt is Measures, Calculated Measures, Derieved Measures?
10. Wt are the Dimensions used in your Project?
11. PARTITION AND NAMEDS SET
12. WRITE A QUEARY TO GET TOP 2 SALES USING MDX QUEARY
13. How many ways we can deploy SSAS Cubes?
14. WHAT IS DATA REGION
15. For analyzing the CUBE dimension values how many AS languages available ?
Ans: 4
MDX, XMLA, DMX
16. Wt is Partition in SSAS?
17. New Features in SSAS 05,08,08R2,12?
18. Can you create a hierarchy for attributes in a different Dimensions?
Ans: yes you can create dimension wise also.
19. Calculated Members, KPIs?
20. Wt is SSAS & Why we USE?
21. How will you provide a MANY-TO-MANY relation to a cube?
22. How did you get NOT NULL values while writing a MDX query?
23. Roles in SSAS project?
24. You want to use a perspective in an MDX query. How do you select the perspective?
Use the Cube Selector in the MDX Query Designer to select a perspective.
Others
1. Tell me About Ur Self?
2. Define DWH and briefly explain the 2- approaches?
3. What is Fact table? And its types?
4. Wt is Dim table , and its types?
5. How do you create a Sorragate key and explain?
6. Types of schemas and wt type of schema you used in your project?
7. Star schema and snowflake schema which is better?
8. Wt is Junk Dimension and what type of data it contains?
9. Wt are the Dimensions used in your Project?
10. Types of OLAP? And wt type of OLAP used in your Project?(HOLAP, MOLAP, ROLAP,DOLAP)
11. Tell me about the schemas? Wt type of schema you used in your project . why use snowflake schema?
12. Wt is Data Model & DWH?
13. Why the DWH is called as Historical DWH?
14. Wt is Sorrogate Key?
15. Wt is Hierarchy ? N how to create it?
16. Which data model your project is following?
17. How do you test unit test cases in your current project?
18. Tell me the project architecture?
19. Tell me ETL process of your project?
SQL Server:
1. How to find a column existence in a Database of SQL server?
2.
Ans’s:
SQL Server:
1.How to find a column existancy in SQL Server?
SELECT c.name AS ColName, t.name AS TableName
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%MyName%'
Or
USE AdventureWorks
GO
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%EmployeeID%'
ORDER BY schema_name, table_name;
Or
SELECT distinct(TABLE_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%EmployeeID%'
(The above is for Including Views)
Or
SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name like '%EmployeeID%' )
(Note: Including Stored Procedures also)
No comments:
Post a Comment