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

how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.

1 4110

explain unit testing,systemtesting,integrated testing

CSC,

1 7013

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

Patni,

2 6117

how many session run unix environment what command using ?

HCL,

1 7355

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

IBM,

5 9906

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

Wipro,

5 9304

What is degenerated dimention table?

Patni,

7 10885

You have a data set of 100 observations,how can you restrict the output so that the output has only data from row no. 10 to row no. 20

9 12550

what are the unix commands to start the wrk flow ?

Accenture, TCS,

4 12734

what is prime numbers? how we can get plc write sas code?

Icon,

5 18829

how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this

HCL,

5 15446

how many stages are there in Datastage... Please clarify mee??

3 8560

What is junk dimention?

Patni,

3 8250

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

Patni,

4 9313

How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?

4 12604

Un-Answered Questions { Data Warehouse }

Hi, If anyone has base SAS certification dumps, please share.

1932

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2305

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1193

What is dimensional table? Explain the different dimensions.

1262

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1231

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

838

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

1164

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2759

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

2854

explain in detail about type 3?

1078

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

2054

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

4249

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2168

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2814

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