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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

what is Forward,Reverse and Re_engineering?

0 Answers  


Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

0 Answers  


Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com

1 Answers  


Eliminating of duplicate records without using dynamic lookups

3 Answers  


How many steps etl contains?

0 Answers  






What is partitioning? Explain different types of partitioning?

0 Answers  


Explain different types of partitioning?

0 Answers  


How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

1 Answers  


1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,


Explain and compare etl & manual development?

0 Answers  


what is the difference between date cache and lindex cache?

1 Answers  


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

1 Answers   QualTech,


Categories