![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)? Latest Answer : Dimension Mapping: The mapping which uses target as one of the dimension is called dimension mapping, suppose a warehouse has 4dimension tables and 1 fact table that is a star schema of 4 dimensions we design 4 dimension mappings to load data into 4 dimensions ... Latest Answer : CREATE OR REPLACE PROCEDURE TIMEDIMBUILD (p_start_date IN DATE, p_end_date IN DATE)AS v_full_date DATE; v_day_of_month NUMBER; v_day_of_year NUMBER; v_day_full_name VARCHAR2(30); v_week_number ... The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use? Read Answers (4) | Asked by : Deshaireddy 1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file? Read Answers (4) | Asked by : pratyusha What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys? Read Answers (5) | Asked by : kishore What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both? Latest Answer : Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition.Static cache - can be configured as connected as well as unconnected lookup. Supports lookup on flatfile. ... Read Answers (3) | Asked by : senthilkumarselvaraj Latest Answer : Essbase is a multidimensional DBMS and Hyperion performance suite is a set of BI tools. ... Read Answers (1) | Asked by : karthik mani Latest Answer : global repository in 7.1 versionnew cutom transformation,normalizer transformation added in 7.1 ... Read Answers (2) | Asked by : raj
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||