Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks

2 3125

how do you pull data from equifax?tell me the process?

Synchrony Financial,

1798

what are the three main credit bureau names

Synchrony Financial,

1 3026

How can you join two tables without any common column present in them?

TCS,

1 3705

List the various vector functions used in ab initio with syntax.

1 19069

I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1758

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1777

What is difference between Union and Union All ?

L&T,

1 3449

Explain your project of banking domian.

Cap Gemini,

1652

What are the difference between merge,auto merge and extended merge ?

Cap Gemini,

1 2813

Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS

Accenture, HSBC,

1 3012

i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.

L&T,

4 11654

how to insert header after each group.

IBM,

1 3041

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1910

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

CTS,

1632

Un-Answered Questions { Data Warehouse }

What is blocking transformation?

1144

Can I access intelligent cubes without olap services?

1046

What is the sql query overwrite in source qualifier in informatica

1090

Explain the different types of data warehousing?

991

What are the differences between sql override and update override?

1100

How can you communicate with web server (apache or iis) from coldfusion?

1119

What is the purpose of Dataware Control?

1048

Give an idea of system variables.

1036

Define bulk load mode?

What is the difference between er modeling and dimensional modeling?

1149

How identifying bottlenecks in various components of informatica and resolving them?

1132

Explain what is sort component in abinitio?

1104

Have you used macros? For what purpose you have used? : sas-macro

1041

How can you force the optimizer to use a particular index?

1058

What is data transformation manager process?

1156

For More Un-Answered { Data Warehouse } Questions Click Here