1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

 1763

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

HP,

1447

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

HP,

1 2397

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

IBM,

1303

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

Accenture,

1 2574

How do you join more than 3 flat files in informatica?

ITC Infotech,

1 2411

Useful UNIX commands regular/frequently used

Deloitte,

1 3596

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

 1260

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

 1 1815

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

 986

what is repositery?

IBM,

1280

Why the workflow is failed after running two hours in informatica?

GE,

1 2115

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

 1034

if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

Accenture,

930

What's the difference between VAR A1 - A4 and VAR A1 - A4?

Quintiles,

1 4022

Un-Answered Questions { Data Warehouse }

name several ways to achieve efficiency in your program? : Sas programming

560

What are the types of studio present in Cognos?

606

Explain when to use local filter and when to use global filter?

590

How is MLOAD Client System restarted after execution?

587

What are vldb properties?

535




Explain true primary keys?

540

How to run a query in teradata?

572

Explain the different dimensions.

540

What are global filter and how they differ from column filter?

523

8. How much supervision have you typically received in your previous job?

1819

can u give example for factless fact table

5496

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1436

Explain by-group processing?

574

explain the concepts and capabilities of business object? : Sas-bi

527

name the prompt which are available in cognos?

5

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