2023 2024 EduVark > Education Discussion > General Discussion


  #1  
June 1st, 2016, 03:28 PM
Unregistered
Guest User
 
HCL SSIS Interview Questions

Hello Friend , Here My Sister Searching for Sample Interview Questions Which Asked in Previous year HCL SSIS Interview , Would you please Provide me Same ?
Similar Threads
Thread
HCL Interview Questions
HCL ASP.NET Interview Questions
Interview Questions for IAS
MTS Interview Questions
HCL WPF Interview Questions
WCF Interview Questions HCL
HCL PMO Interview Questions
HCL SQL DBA Interview Questions
HCL VB.Net Interview Questions
Interview questions in asp.net
Microsoft SSIS certification
CTS MBA Interview Questions
Sas Sql Interview Questions
NDA Interview Questions
Interview Questions After Mba

  #2  
June 1st, 2016, 03:30 PM
Super Moderator
 
Join Date: Mar 2012
Re: HCL SSIS Interview Questions

Friend as you said your Sister want to get Sample Interview Questions Which Asked in Previous year HCL SSIS Interview , Here Providing Some Sample Questions :

1. Design a SSIS package for the following requirement. Create a table, load data and move to the different schema using SSIS.

2. Are you following any framework for ssis?

3. How to execute parent and child ssis packages? Locate 1000 files location?

4. How to add users to a database using SSIS?

5. Which tasks should be used to import a million records txt files?

6. What are the configuration options for parent child packages?

7. What is the new configuration option added in SQL Server 2012?

8. What is the difference between “Execute SQL” and “Execute T-SQL” tasks?


(9) I have a table with a column EmployeeName. The data inside this column is like a, b, c, d etc.
Now, I want to show the data as row items like a in row1, b in row2, c in row3 etc...
How can you achieve this in sqlserver?

(10) Write a query to get DepartmentName and highest salary of each department?

(11) Write a query to get second highest salary in sqlserver?

(12) What is the slicing of the cube?

(13) Difference between MOLAP and ROLAP?

(14) Explain me about SSIS Architecture?

(15) How to remove duplicates from a flat file using SSIS?

(16) How to load the data from staging server to data warehouse? And, How to load the data in dimension tables and fact tables?

(17) How frequently you insert the data into data warehouse?

(18) How and where will you maintain last run details when you are loading the data incrementally using SSIS?

(19) How to load the data into fact table?

(20) How will you perform increment load using SSIS?

(21) What is the format of date dimension in your project?

(22) How do you deploy a package in SSIS?

(23) What are the package configurations in SSIS?

(24) How do you handle errors in SSIS?

(25) How do you generate error logs in SSIS?

(26) In which table the log information will get stored if you enable SSIS log provider for Sqlserver?

(27) How to protect a package and what are all the options have you used in your project?

(28) What are the synchronous transformations and Asynchronous transformations in SSIS?

(29) What are the Blocking transformations, Partial Blocking transformations and Non-Blocking transformations?

(30) What are the steps involved in creating a cube?

(31) How to provide a security to the cube?

(32) What is impersonation?

(33) What are the types of Hierarchies in SSAS?

(34) Give me an example for the Un-natural Hierarchies?

(35) What are the relationships available between Fact and Dimension tables?

(36) What is KPI and what are the commonly used properties in KPI?

(37) What are the Actions?

(38) What are the Perspectives? Can we see the data in a row level or column level when working with Perspectives?

(39) What is the Derived measure? How will you implement this?

(40) How many types of reports have you developed in your project?


Quick Reply
Your Username: Click here to log in

Message:
Options



All times are GMT +5. The time now is 07:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Content Relevant URLs by vBSEO 3.6.0

1 2 3 4 5 6 7 8