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

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 6100

ename like ibm,tcs,hcl need display those records only how?

2 6571

convert yyyy mm dd to dd mm yyyy?

4 16430

how to closeing records after 10,000 records come?

3 6527

how to add a new records into source?

2070

in oracle target stage when we use load option and when we use upsert option?

2336

How To find the location of APT_confid file

CTS,

2 9093

it is possible to link two universes of separate functional domain ?

IBM,

1 4958

how u link universes of same functional domain ?

Business Intelligence Analytics, IBM,

2 6046

How to Rename Library?

3 11463

what is difference between Rich client web intelligence and Boxir2 web intelligence

TCS,

3 17918

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2, Please let me know how can we acheive this in informatica Thanks in advance

4 8284

What is snapshot thumbnail

3 6098

difference between impromptu and cognos8

HCL,

2500

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

Deloitte,

7 27612

Un-Answered Questions { Data Warehouse }

What are the limitations for memory allocation for SAS variables

1557

what are the benefits of data integration? : Sas-di

1193

What are the advantages of informatica?

1066

What is a shortcut and copy in Informatica and how two are different with each other?

1255

What are the functions performed by bynet?

1096

Which statement does not perform automatic conversions in comparisons?

1864

What is Index Caches size?

1171

Mention what is a partition and what are the different types of partition components in abinitio?

1243

What is microstrategy intelligence server?

1088

What are the tools available for etl?

1040

What is recovering sessions?

1004

Can we change Dynamic to Static or Persistent cache? If so what happens?

2268

What is fact table? Explain the different kinds of facts.

1133

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5200

Can we get 1st record through Informatica(without sequence number).

1527

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