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

can you use flat file for repository?why?

TCS,

2 7292

what is hash table in informatica?

Zensar,

1 7131

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

TCS,

4 9628

every reports have docid,when i export a report docid will change or not?

Zensar,

4 10832

Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.

Teradata,

4 14183

calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15

6 8458

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

Wipro,

6 11999

I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

IBM,

4 10361

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 7659

hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........

TCS,

1 4562

How would you compile all macros from a folder in a study, within the autoexec program?

1 4979

how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com

TCS,

2 17945

flat filevalidation in informatica

Hewitt,

2157

how to connect to a flatfile through ftp in informatica

TCS,

1 14305

wat is called Model dimension?

IBM,

2087

Un-Answered Questions { Data Warehouse }

Define Job control?

1152

How were the reports scheduled and how to resolve unexecuted documents?

2676

How to generate iqd file from framework manager?

965

How can sas program be validated?

1041

How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1934

How do you determine the number of sessions?

1064

How can we improve performance of data stage jobs?

1018

What can be the size of largest dataset in SAS?

1234

What are the steps needed to create a simple basic datastage job?

1240

how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

4007

I have a few records just I want to store data in to targets cycling way how?

2369

Briefly describe lookup transformation?

1046

define cognos reporting tool?

Is it possible to create multiple domains on a single Informatica server?

1245

What is thumbnail?

975

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