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
what is Forward,Reverse and Re_engineering?
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.
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
Eliminating of duplicate records without using dynamic lookups
How many steps etl contains?
What is partitioning? Explain different types of partitioning?
Explain different types of partitioning?
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. 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
Explain and compare etl & manual development?
what is the difference between date cache and lindex cache?
how do u decide whether u need to do aggregations at database level or at Informatica level?