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

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

IBM,

1 7228

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

IBM,

2 7942

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

IBM,

1 5596

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

Accenture,

2602

can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com

1 5480

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 8567

How to transfer file from one system to another system in UNIX?which command to be use?

Cap Gemini, TCS,

4 12263

How to create a doccument in datastage?

Cap Gemini,

1 7811

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

Reliance,

2459

What is the function in Transformer stage can act as Rank Function in oracle

Reliance,

1 6730

How can we do null handling in sequential files

Reliance,

3 15585

on how many columns we can perform aggregation in the aggregator stage?

Reliance,

2 6834

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

Syntel,

2305

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

HCL,

2257

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

TCS,

7 33476

Un-Answered Questions { Data Warehouse }

what are 3 tech challenges/ common issues you face?

2356

-----------Diff b/w OLAP and RDBMS?

2064

what is model and say about process how to create model and how to test model?

1077

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

789

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7200

Where do the datastage jobs get stored?

1229

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2191

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

821

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2292

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2368

How does a rank transform differ from aggregator transform functions max and min?

1220

How Metrics Studio is better than Report Studio?

2620

How necessary is it to be creative in your work?

2496

what are the dimensions that you have in your current project?list them?

2038

Can you implement SCD2 using join, transformer and funnel stage?

1567

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