Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Data Warehouse Interview Questions
Questions Answers Views Company eMail

Explain about cumulative Sum or moving sum?

Informatica,

1043

Explain lookup transformation source types in informatica

Informatica,

1098

What is a transaction control transformation?

Informatica,

1208

Define mapping and session?

Informatica,

1038

Design a mapping to load the cumulative sum of salaries of employees into target table?

Informatica,

1505

How to create or import flat file definition in to the warehouse designer?

Informatica,

1070

What are ETL Tools?

Informatica,

1118

What are the types of data warehouses?

Informatica,

1526

How to partition the Session?

Informatica,

1113

How to create Target definition for flat files?

Informatica,

1227

How do you handle two sessions in Informatica

Informatica,

1165

What are the guidelines to be followed while using union transformation?

Informatica,

1144

Which transformation should we use to normalise the COBOL and relational sources?

Informatica,

1213

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

Informatica,

1082

What is aggregate cache in aggregator transformation?

Informatica,

1145


Un-Answered Questions { Data Warehouse }

What is the need of etl tools?

1120


How did you plan your Data ware house project?

2307


diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2556


What is etl process? How many steps etl contains?

1034


r u done any partitions in ur project?

1827


Explain what is sort component in abinitio?

1104


What is the differentiate between data file and descriptor file?

1363


What is the size of the cube?

976


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1345


-------------How you design DWH?

2313


Explain conformed fact?

973


Explain what three things do you consider to be the most important factors for a manager?

1011


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2133


How many types of joins are there in teradata?

978


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2064