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

what r the claims? how many type of claims we face from client side?

1 4451

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

TCS,

2 13147

what is the difference between static and dynamic

TCS, Wipro,

4 25784

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

IBM, TCS,

17 44315

what is the difference between Cognos EP7 series and Congos8?

Hexaware,

2 10569

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

Genpact, iFlex, TCS,

7 36164

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?

Cap Gemini, iFlex,

7 25881

What is the basic relationship between measures and dimensions in transformer modelling

5 9947

in which situations do u go for snowflake schema ?

TCS,

2 8702

in which situations do u go for starflake schema ?

TCS,

6 20126

in which situations do u go for scds ?

TCS,

3 9214

in which situations do u go for sequence generator ?

TCS,

2 9697

how do u get the first record from 50,000 records ?

TCS, UBS,

10 20220

what is incremental loading ?

CTS, IBM, Oracle, TCS,

12 58284

how many tasks are there in informatica ?

DELL, iGate, TCS,

15 51569

Un-Answered Questions { Data Warehouse }

how many reports have u created ? explain a few.

2160

Explain how to generate iqd file from framework manager?

1022

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

1997

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

2094

Write the unconnected lookup syntax?

1148

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

Demonstrate experience in maintaining quality process standards?

2672

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334

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

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

3442

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

2860

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2794

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

1150

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

6077

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