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

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 9570

source file is having 5 records while moving into target it want to be 10 records

IBM,

4 11645

where exactly determinants are used in cognos framework manager?

Satyam,

4 27059

how will compare two mappings in two different repository?

Real Time, TCS,

2 32290

without using emailtask how will send a mail from informatica?

3 10198

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

IBM, TCS,

5 9319

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

TCS,

5 8888

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2161

Which Teradata concept allows more than one model generation?

TCS,

1 10954

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 7989

what is meant by report busting

TCS,

2 6998

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 4169

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

IBM,

3 5819

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

Cognizant, IBM,

1 2018

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

IBM,

1 3165

Un-Answered Questions { Data Warehouse }

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

1993

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

6059

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2425

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4788

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..

1953

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

2855

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654

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

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2201

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3648

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

1194

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

1167

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

1074

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1840

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

2054

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