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

I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM

TCS,

39 39971

How can you import XML repositories exported from different tools like ODI

3557

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2186

in static and dynamic which one is better

2 5299

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 10297

wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?

2248

how can u connect the client system directly at any time?

IBM,

1 6829

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

IBM,

1 10929

HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

Infosys,

1 10524

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

Infosys,

2 9519

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

Infosys,

3 14106

can we see the data in fixed width file? how can u change the datatype of fixed width files?

Infosys,

1 9539

types of errors in datastage?

Reliance,

2 9991

on how many columns we can perform aggregation in the Aggregator stage?

Reliance,

3 11441

how can we do null handling in sequential files

Reliance,

2 8709

Un-Answered Questions { Data Warehouse }

What are the different types of parallelism in ab initio?

1222

What is informatica worklet?

1070

How many Key we can define in remove duplicate stage?

1388

Triggers,VIEW,Procedures

1225

How do you achieve schema object version control?

1006

Explain the hierarchies level data warehousing.

887

What is the difference between drill through, drill across?

1086

Explain what are the advantages of query studio compared to report studio?

1025

What are the commands to make a new table, change a table and remove a table in teradata?

1132

can metadata be manually edited? If yes, how?

1030

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

808

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

1255

What is a sequence generator transformation?

1023

What is the difference between class statement and by statement in proc means?

1301

How to convert RGB Value to Hexadecimal values in datastage?

4000

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