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?

 1765

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,

1449

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 2401

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

IBM,

1307

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 2578

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

ITC Infotech,

1 2418

Useful UNIX commands regular/frequently used

Deloitte,

1 3597

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

 1262

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

 1 1822

(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.

 990

what is repositery?

IBM,

1284

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

GE,

1 2117

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?

 1035

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,

932

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

Quintiles,

1 4030

Un-Answered Questions { Data Warehouse }

What actually a project contains?

637

What is mapping debugger?

563

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

667

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

529

what is a prompt value in report studio and variables ?

2156




What is Additive function?

1546

What are the difference between ceil and floor functions in sas?

694

What is a Framework manager?

556

I need level 2 to 5 sas using companies in india

1917

Explain what is the use of proc gplot?

690

How many areas for files does datastage have?

631

What do you mean by teradata intellicloud?

587

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1497

What is rank transformation?

564

Explain what are non-additive facts?

552

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