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

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 2767

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

HCL,

1511

Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

IBM, Saama Tech, Wipro,

1 1897

How to increase performance without changing anything in mapping.( In prod)

IBM, Saama Tech, Wipro,

1264

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

IBM, Saama Tech, Wipro,

1194

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

1336

What are the different ways to deploy the code in informatica?

IBM, Saama Tech, Wipro,

1 2431

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

Accenture, Saama Tech, TCS,

2 3790

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

Cap Gemini,

1 2909

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

CTS,

1376

On which transformations you created partitions in your project?

Cap Gemini,

1347

Find 2 highest sal from each dept who have completed 5 year in org

Wipro,

1609

if collect stats but it show low confidence why?

IBM,

1687

can anyone suggest best free Talend data integration training online

1690

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1497

Un-Answered Questions { Data Warehouse }

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

4001

How to RD using transformer?

1424

what is the use of proc sql? : Sas programming

1133

Is AWS Redshift a stored procedures?

What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2534

differentiate between two-tier, three-tier and four-tier connections.

986

What are all the different types of prompt in cognos?

1051

What is the size of database for you project?

1597

What are the types of caches in lookup?

1048

Explain the data type of the surrogate key?

950

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2357

Describe what the SQL Server tempdb and tlog files are used for?

2340

How do we call shell scripts from informatica?

1120

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1084

Mention what the difference between “look-up” file and “look is up” in abinitio?

1312

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