Cybage Interview Questions - 2

SQL: Explain types of joins  and how they work? Explain index architecture?  H…

Cybage Interview Questions - 1

SELECT 'a'+a SELECT '1'+1 Can illustrate index accept 0 (zero) …

Cognizant Interview Questions

How to append 2 MDX queries? How to pass array value to each loop and from loop…

CloudMoyo Interview Questions

SSIS Tell me about yourself  Tell all technical experience till now and your r…

CapGemini Interview Questions - 2

Company :Capgemini     1. Entire project work flow in ssis what sources and transform…

CapGemini Interview Questions - 1

1. Rate your self in sql-ssis 2.tell me about your self. 3. Tell me brief in you…

BristleCone Interview Questions

SSIS: How to design a package:  There are 2000 excel file and need to  import in…

Cybage Interview Questions - 2

SQL:
  1. Explain types of joins  and how they work?
  2. Explain index architecture?  How index works?
  3. Types of indexes?  Relation between insert and index?
  4. What are functions? Use of Functions?
  5. Explain types of functions with example?
  6. Explain procedures and their types
  7. Difference between Procedures and Functions
  8. What is View? Explain it’s types, use with example
  9. Can we perform DML operations on Views
  10. Identity column? How to ON/OFF identity
  11. Delete vs Truncate on Identity columns
  12. If we delete 5 records from table having an identity column and insert same records again. Then which place these records are inserted and what will be the identity column value of those records?
  13. Difference between DELETE and TRUNCATE
  14. Can we delete records from table using case statments?
  15. Difference between Primary Key and Unique Key?
  16. What is Primary Key and Composite Key with Example?
  17. SQL query optimization techniques
  18. SQL Profiler tuning?
  19. DB restore and Backups
  20. Steps of job scheduling
  21. Ranking functions
SSRS:
  1. Different types of reports and their examples?
  2. Properties of Drill Down, DrillThrough and SubReports?
  3. Chart Reports?
  4. Which types of expressions we can use in SSRS reports?
  5. Parameterised reports
  6. Use and purpose of SSRS reports
SSIS:

  1. Transformation Tasks in SSIS?
  2. Use of Copy Column and Derived Column? Difference between them
  3. Use of LookUp
  4. Difference between Fuzzy Lookup and Fuzzy Grouping?
  5. What is Conditional Split? How it works?
  6. What will be the output of Conditional Split?
  7. Package Configuration Steps and Types?
  8. Package Deployment Types and Steps?
  9. Use of Execute SQL Task?
  10. How to Handle exceptions in SSIS?
  11. How to schedule Packages?
  12. Some questions on your project?
Posted by Saudagar Jadhav at January 02, 2016 0 comments
Labels:

Cybage Interview Questions - 1

  1. SELECT 'a'+a SELECT '1'+1
  2. Can illustrate index accept 0 (zero)
  3. Explain indexed view
  4. There are three Stored procedures SP1, SP2, SP3.
 All three procedures has transactions.
SP1 calling SP2,  SP2 calling SP3
SP3 has error, then can SP1 execute sucessfully?
  1. Which is faster delete or truncate
  2. What is filtered index?
  3. What is clustered index?
  4. String “you, are, doing, great, work”
How to calculate each word length? Ex. length you=2, length are=3 etc
  1. Explain Union and union all?  differences between them
  2. What is identity column?
Tab1 Tab2
Id1 Col2 Id2 Col2
1 A 3 P
2 B 5 Q
4 C 6 R
6 D 1 S
I want to Insert Tab2 data into Tab1, Both Id1 and Id2 columns are identity column. What will happen while inserting data?
  1. Difference between VARCHAR and NVARCHAR
  2. How to find second highest salary?
  3. I want to insert value in Col D by Dividing Column B/C.How to insert this without any error
Table
A B C D
1 5 0 NULL
2 6 0 NULL
3 7 2 NULL
4 8 3 NULL

  1. Which are stored procedures you developed in your project?
  2. Difference between temporary table,  table variable and CTE
  3. Explain query Optimisation
  4. Explain performance tuning
  5. Explain error handling
  6.  Explain different operators available in execution plan
  7. How to calculate table size?
  8. Explain additional features in SQL server 2016?
  9. How we can see temporary tables created in database?
Posted by Saudagar Jadhav at January 02, 2016 0 comments
Labels:

Cognizant Interview Questions


  1. How to append 2 MDX queries?
  2. How to pass array value to each loop and from loop to Pass to each individual execute sql task and it’s precedence?
  3. Difference between Unicode and NonUnicode
  4. Display 1 to 50 numbers using CTE
  5. Can we have index on CHAR? If yes,  on leaf node what is get stored? Data or Pointer?
  6. Difference between script component And script task?
  7. For subscription, Where Mail or SMTP Server will configure?
  8. SqlCMD for Automation
  9. How to Process Partition using sqlcmd and xml command?
  10. Factless Fact used for join 2 tables
  11. How to separate Comma separated values in tabular format with employee id column?
  12. New feature of DB configuration to synch procedure on every server present in SSDT
Posted by Saudagar Jadhav at January 02, 2016 0 comments
Labels:

CloudMoyo Interview Questions

SSIS
  1. Tell me about yourself 
  2. Tell all technical experience till now and your role in project
  3. What is join?  explain different types of joins
A B
1 1
1
A B
1 1
2 2
3 null
4
null
  1. Tell your SSIS project flow
  2. Write control and data flow for below
Source DB----------------> destination DB 
  1. If records updated in source DB reflect in destination DB using SSIS
  2.  Source DB A
Source DB B-------------->   destination DB A INNER JOIN DB B

  1. What is lookup merge and merge join
  2. Condition for merge join
  3. Why data has to be sorted in merge join?
  4. Can we do question 5 task using join Approach?  how? 
  5. Is it feasible?
  6. On which SQL server you ran packages?
  7. What is  SSIS deployment? In Which way you have deployed it?
  8. What is SCD?  business key and surrogate key?  where can we find it?
  9. Do you know  limit of bulk insert?
  10. What is indexing ? Types of indexes?  differences between various types of indexes?
  11. What is data warehouse?
  12. What is fact and dimensions?  explain with example
  13. What is mean by normalisation and denormalization?
  14. What are different types of schemas?
  15.  difference between star schema and  snowflake schema?
  16. Which of above is  normalised?
  17. Which falls under denormalized?
  18.  how to use facts and dimensions?
  19. What is effect of dimensions on fact table?
Posted by Saudagar Jadhav at January 02, 2016 0 comments
Labels:

CapGemini Interview Questions - 2

 Company :Capgemini    

1. Entire project work flow in ssis what sources and transformation have you applied.

2. Transaction In SSIS Package

3. Have you used temp tables in packages? Is there any property that we need to take care of?

4. Which kind of dimension have you implemented through package, have you know type of dimension

5. Type of Fact

6. SCD and it's Type, have you faced any difficulty?

7. Have you done package configuration, how do you manage your connection in different environments like UAT,Production,development.

8. If there is any package that fails in production and I want to know what is the reason for it and we people do not have access in the production environment, how do you find out the error?

9. How do you trace your query from a performance point of view?

10. Have you worked on column store index? disadvantage of column store index

11. Scenario: If I have 2 tables,  1st table contains 1000 rows along with duplicate data, without any primary key,indexing and 2nd table has composite key  (column 1 and column2) then I want to insert this data without duplication. How will I do that?

12. Have you used intersect and Except? performance wise which is better as I can get same output with join as well

13. CTE?  Can we create an index on CTE?

14. Have you used triggers?

15. Reporting Tool, have you worked on power BI?

16. Cascading parameter in SSRS

Posted by Saudagar Jadhav at January 02, 2016 0 comments
Labels:

CapGemini Interview Questions - 1

1. Rate your self in sql-ssis
2.tell me about your self.
3. Tell me brief in your project & architecture.
4. What's the difference between where and having.
5.what is fact and dimension 
6. What's the difference between delete.
7. What is index tell me brief.
8. Types of temp table.
9. how you will get the data.
10. What was the most difficult scenario faced in ssis.
11. What kind of errors you can handled in ssis.
12. Break points. 
13. Check points. 
14. Event handler.
15. performance tuning in ssis.
16. Deployment in ssis. 
17. Blocking transformations.
18. SCD transformation brief explanation.
19. Term extraction.
20. Isolation properties.
21. Derived column expression.
22. Self join.
23. Types of joins explain briefly.
24. Character map transformation purpose.
25. Real time scenarios in sql-server.
26. Performance tuning in SQL -server.
27. Merge join.
28. Union all.
29. Multicast.

30. Error handling.
Posted by Saudagar Jadhav at January 02, 2016 0 comments
Labels:

BristleCone Interview Questions

SSIS:

  1. How to design a package:  There are 2000 excel file and need to  import in SQL server
  2. How to design a package:  Excel to SQL server destinations with file name starts with “finance” only. 
  3. If there is parent package and child package. There is an error in one of the packages. How can we identify whether error in parent package of child package?
  4. Duplicate records needs to Delete from Destination on the basis of Source and import it and put it into another destination
  5. All records from excel file to insert in SQL destination except first 10 records and Rows 15 to 40 needs to insert in sql server rest don’t
Posted by Saudagar Jadhav at January 01, 2016 0 comments
Labels:
Subscribe to: Posts (Atom)