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

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

1 3556

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

Wipro,

5 11892

if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record

HSBC,

4 10311

What is difference between 8.1 , 8.5 and 9.1 ?

IBM,

1 16282

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

CSC, iNautix,

3 18642

Hi all, i have a requirement in Conditional drill through. I have a list report with Cities India, UK, USA, China, japan, Canada.... In the above cities i want to give Hyperlinks(Drill) for Only India & UK. Could you please send me the steps????

1 5524

Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....

2 6290

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

Caterpillar,

3 12034

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

Motorola,

2 6401

Why joiner transformation does not allow the aggregator transformation and expression transformation to join

2 10258

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 21702

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

Thomson,

1 2753

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 6724

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

Cap Gemini, IBM,

4 13566

what is set mapping in datastage??

ADP,

2 11344

Un-Answered Questions { Data Warehouse }

What are the data types present in bo? What happens if we implement view in the designer and report?

1083

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1998

Explain how to generate iqd file from framework manager?

1024

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1245

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2069

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2268

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

848

Explain scd type 3 through mapping.

1078

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1964

How to add default rules in transformer?

1288

What is dimensional table? Explain the different dimensions.

1273

explain in detail about type 3?

1093

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2438

Demonstrate experience in maintaining quality process standards?

2677

how to generate the test data in sas without input data? : Sas-administrator

1207

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