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

ETL Interview Questions
Questions Answers Views Company eMail

what is the difference between OLTP database and data warehousing database?

3 7269

what is data modeling?

2311

what is the difference steps for data modeling?

2593

what are the data modeling tools you have used?(polaris)

1993

what is the difference between cardinality and Nullability?

2941

what is Forward,Reverse and Re_engineering?

2193

what is the meant by Normalization and de-normalization?

2 8705

how would u estimate the size of Aggregator transform data and index cache?

2413

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 4291

how would u estimate the size of Lookup transform data and index cache?

1 3943

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 4679

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2886

how do u really know that paging to disk is happening while u are using a lookup transform?

2426

how do u set partition points in the mapping?

Quintiles,

2235

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 3722


Post New ETL Questions

Un-Answered Questions { ETL }

what make u disappointmnets in u r career

2191


When do we analyze the tables?

957


How many types of transformations supported by sorted input?

1217


Explain me ETL project architecture in Detail?

2366


Define slowly changing dimensions (SCD)?

1051


what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2626


A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1854


What is data modeling and data mining?

969


1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

2239


explain the methodology of Data Warehousing?(Polaries)

2016


How many steps etl contains explain with example?

960


Compare ETL & Manual development?

941


When do we go for the tools in the market?

943


What is partitioning? Explain different types of partitioning?

1239


when will use SQL override in a lookup transformation?

2288