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

Difference between slicing and dicing with example?

2 17880

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

IBM,

1 7111

How to Check the source record count from traget table.

IBM,

5 14515

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

iGate,

3 13373

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 10460

whats the difference between previous version of cognos and cognos 8 BI?

IBM,

2 5675

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

IBM,

1 10746

what is service oriented architecture in Informatica 8 version

Cap Gemini, IBM, Systech, TCS,

1 10694

what is incremental data aggregation?

IBM,

3 7254

Hi..every one please tel me the answer for my question, how many project sources we can create in Metadata?

3 7480

What is Element cache and give me one example?

2 9468

8.what is mapplet ?give example?

2 12997

How we can create the Intelligent cubes in Microstrategy?

2 14736

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 12673

What are the types of presistent cache in look up tr.

IBM,

1 2130

Un-Answered Questions { Data Warehouse }

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1200

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

2060

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

846

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

1174

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

1176

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

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

2262

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

4260

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

1144

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?

1100

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

1173

What is aggregate table and aggregate fact table ... Any examples of both?

1118

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127

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

1214

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

2149

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