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 7385

what is hash table in informatica?

Zensar,

1 7232

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 9768

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

Zensar,

4 11007

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

Teradata,

4 14375

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 8719

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

Wipro,

6 12203

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 10497

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 7775

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 4632

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

1 5062

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 18053

flat filevalidation in informatica

Hewitt,

2204

how to connect to a flatfile through ftp in informatica

TCS,

1 14394

wat is called Model dimension?

IBM,

2142

Un-Answered Questions { Data Warehouse }

When and why we should use Redshift Spectrum?

What is a macro routine?

2793

How to create different types of templates?

1037

State the difference between an operational datastage and a data warehouse?

1188

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2060

What is database exceptions in teradata?

1004

What is the difference between a cascading report and drill through report?

1124

what other sas products have you used and consider yourself proficient in using? : Sas programming

1168

Name the different lookup cache(s)?

1297

how to implement scd2 in datastage 7.5 with lookup stage

5671

What does proc print, and proc contents are used for?

1227

How do you call a store procedure within a transformation?

1055

How many types of sessions are there in informatica.please explain them?

1214

what will be the contents for a functional requirements specifications

2422

How do you manage the Parameter files while migrating your data from one environment to another environment?

1070

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