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

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

Wipro,

2110

what is option year cuttoff in sas

L&T,

2 7787

what is treatment emergent events and treatment emregent adverse event

2407

what is lifetest

Cognizant,

1 5145

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

Polaris,

4 8629

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

Accenture,

6 11332

What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.

DELL,

2 7651

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1876

1829

I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.

3 7433

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

TCS,

1 4628

i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 5101

actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........

1 4019

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1699

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

TCS,

3 13616

Un-Answered Questions { Data Warehouse }

How many transformations can be used in mapplets.

1935

What is the difference between informatica and datastage?

1227

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

933

hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

2127

Explain the data types present in bo n wht happens if we implement view in the designer n report?

981

Give an idea of system variables.

1036

Which warehouse using in your datawarehouse

2185

Describe primary index in teradata?

1000

Explain about core dimension,

985

How far Redshift is better in performance as compare to other data warehouse technologies?

define prolog tab?

What is status code in informatica?

1019

How to pivot row data using informatica?

956

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1100

What does update strategy mean, and what are the different option of it?

1091

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