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

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

IBM,

1 2350

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

IBM,

1 3634

HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?

1 3971

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

TCS,

3 6645

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

Keane India Ltd,

5 9432

What are the different caches used in informatica?

UST,

3 7419

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

Hexaware,

1 6840

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

Wipro,

1 7336

what is factless fact table?

IBM,

3 8742

Issue with Update override at Target table in Informatica.

2 8863

Wht is difference between content store and content manager?

Satyam, Tech Mahindra,

2 21083

What are the different String functions used in Abinitio?

IBM,

3 59484

What is Is_defined(), Is_null(), Is_Blank()?

TCS,

1 42112

What are the prioritized Rules in as Transform function

1 8757

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

DELL, TCS,

5 13291

Un-Answered Questions { Data Warehouse }

how to generate the test data in sas without input data? : Sas-administrator

1207

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

2313

how many reports have u created ? explain a few.

2162

Explain scd type 3 through mapping.

1078

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

Demonstrate experience in maintaining quality process standards?

2677

EXL informatica Questions

1463

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1214

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

2095

How to add default rules in transformer?

1288

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2304

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

2828

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

2153

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

2095

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

1122

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