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 ...
What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys?
Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data.
In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and wich transformations we r using?and explain logic?
Where exactly dimension and fact tables are useful? Is it source or target?We are importing source directly from database and transforming and loading the data to target.Can anybody please send where they exactly it is useful?
I have a datatype as varchar2 in source table and when I load the data in the target table it is mapped to nclob datatype.when I run the mapping , there are junk values in my target table which has nclob datatype.Could you please let me know how to solve the issue.Thanks in advance
Hi, I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica.The Target are Oracle tables.1-80 columns: 1st target81-200 columns:2nd targetHow can I split that single COBOL file data into two data files and How can I load that data using Informatica.Thanks in Advance
