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 data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

DELL,

2 8657

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

DELL,

1 8169

i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me

1963

how to creat 2 way drilling mode.can any one know this

2211

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

Wipro,

1990

While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.

Emphasis,

2035

How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

Emphasis,

1 5260

specify data stage strength?

1 5361

Can u solve a small query on table the problem is whether it is possible to add extra cells for already existed table i.e if table contains 3 rows n 4 cols (3*4) it is possible to add another cell (4*4)

1 5038

i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)

1954

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 4187

Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

2808

Is it possible to have more than one row on the same table with the same foreign key?

2 6477

Name at least three brands of Database Management Systems

1 4669

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

CTS,

3 14332

Un-Answered Questions { Data Warehouse }

What is data type of the surrogate key?

1004

What is time series wizard? When and how do you use it?

1651

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4722

What are system variables and sequencers in datastage

1118

What are the advantages and disadvantages of reporting directly against the database?

984

What Amazon redshift built for ?

When we save a report in report studio with what extn it save?

1068

In development project what is the process to follow for an etl developer from day1

1725

List some pros and cons of amazon redshift?

Explain and compare pros and cons of start schemas?

1073

How do you define proc in sas? : sas-grid-administration

1087

How do you specify the number of iterations and specific condition within a single do loop?

1110

Could you explain what is enterprise data warehouse?

1150

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

1559

Explain when do we analyze the tables? How do we do it?

1003

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