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

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

Cognizant, IBM,

2 6351

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

Tech Mahindra,

4196

can any one say the which is the best performance in framework manager

1 4920

Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....

2279

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

TCS,

1 9581

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

TCS,

1 10702

Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com

IBM,

2 6508

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1 2046

guys which is the best institute in banglore to learn informatica??

2 5894

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

7103

I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

1 2800

how to delete duplicate records in multi set table without using any tables

Accenture, Nest, South Nests Software Solution, Spiro Solutions,

2 14835

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 12960

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

Atriax,

3 11395

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

1 3907

Un-Answered Questions { Data Warehouse }

Have you have ever worked in unix environment and why it is useful in datastage?

1218

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

What is the purpose of Dataware Control?

1121

What sort of existing documents should business analysts refer to when starting on a new project?

1078

how to generate the test data in sas without input data? : Sas-administrator

1207

what is document design in boxi,have u participate in that

2310

How would you format some text using css to be verdana and bold?

1150

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2069

How to create the source and target database connections in server manager?

1144

Write the unconnected lookup syntax and how to return more than one column.

1176

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1105

Demonstrate experience in maintaining quality process standards?

2677

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1998

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2095

Hi friends, what are the new features in abinito3.0?

2860

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