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

For clinical entire study how many tables will create approx?

TCS,

1 2037

How to read data from flat file source if the data is in paragraph format?

Wipro,

2 4968

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

Wipro,

1 2429

How to set Parameter in Script data source?

1 2497

How to create a cube in Transformer? What is the process? Please mention process thank u

Genpact,

1 1826

Unix command to view the data in a dataset

IBM,

2 6769

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

IBM, PR3 Systems,

4 6766

what is the difference between repository & Intergration service

1 4765

hoe to access second value in mapping parameter if it is having more than one value ?????????????

SS Solutions,

1 1612

What is difference between merged dimension and forced dimension??

1 5257

What is ROWID explain ?

Wipro,

2 4977

when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

2 3583

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 3942

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1 1837

Can we make worklet inside worklet?

1 6967

Un-Answered Questions { Data Warehouse }

what are the data modeling tools you have used?(polaris)

2058

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3442

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4262

What is node? How many nodes and amps used in your previous project?

1173

What is dimensional table?

1164

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2264

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6077

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

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

1078

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1963

Explain about a time when you discovered a more efficient way to do a work task?

1222

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

1144

Write the unconnected lookup syntax?

1148

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2150

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1177

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