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

GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 258 of 305    Print  
How to load the dimension tables from staging areas?

  
Total Answers and Comments: 1 Last Update: May 26, 2008     Asked by: prasad 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
May 26, 2008 04:45:04   #1  
anupama2000 Member Since: May 2008   Contribution: 13    
RE: How to load the dimension tables from staging areas?
We need to create them in warehouse designer according to specification and move them to another folder where you can use that as target by generating them in warehouse.
 
Is this answer useful? Yes | No

 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  ...
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
Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data.
Read Answers (3) | Asked by : boobathi
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?
Read Answers (4) | Asked by : Reddy
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?
Read Answers (3) | Asked by : sree
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
Read Answers (1) | Asked by : mhnoor
View Question | Asked by : radha krishna
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
Read Answers (1) | Asked by : ramki

 Sponsored Links

 
Related Articles

What is Data Dimension

Data Dimension is mainly used in data warehouse implementations. A data warehouse is implemented to that organizations can profit from data driven operation which constitute a major component in running businesses these days. To be effective with a data driven operation, data which is the basis for
 

How To Create High Quality Tables With JavaScript

How To Create High Quality Tables With JavaScript If you are web program developer it is likely that you are creating tables on a daily basis In this article I will show you how to create high quality tables with Javascript within a short period of time One feature that you will want to become famil
 

Load Testing Interview Questions

Load Testing Interview Questions This article provides Software Testing Interview Questions covering Load Testing questions For more Interview Questions Answers related to testing click on links provided at the end of each question set mosgoogle Load Testing 1 What are the uses of load testin
 

Oracle 10g Tutorials -Creating Index-Organized Tables

Oracle 10g Free Training Creating Index Organized Tables Let us learn about Creating Index Organized Tables by Creating an Index Organized Table further by Creating Index Organized Tables that Contain Object Types and also you will learn how to View Information about Tables mosgoogle Creating Index
 

Oracle 10g Tutorials: Altering Tables

Oracle 10g Free Training Altering Tables In this training you will learn about Altering Tables Modifying an Existing Column Definition Adding Table Columns Renaming Table Columns Dropping Table Columns Removing Columns from Tables Marking Columns Unused and Removing Unused Columns Oracle 10g Free Tr
 

Oracle 10g Tutorials : Dropping Tables

Oracle 10g Free Training Dropping Tables In this training you will learn about Dropping Tables Consequences of Dropping a Table CASCADE Clause and the PURGE Clause mosgoogle Dropping Tables To drop a table that you no longer need use the DROP TABLE statement The table must be contained in your schem
 

Oracle 10g Tutorials : Creating Tables

Oracle 10g Free Training Creating Tables In this training you will learn about Creating Tables and Parallelizing Table Creation mosgoogle Creating Tables To create a new table in your schema you must have the CREATE TABLE system privilege To create a table in another user s schema you must have the
 

Oracle 10g Tutorials: Tables

Oracle 10g Free Training Tables In this tutorial you will learn about Tables Summary of Oracle Built In Datatypes Types of tables Restrictions to consider when Creating Tables along with logical databse limits mosgoogle Tables Tables are the basic unit of data storage in an Oracle Database A table
 

Tutorial 66: MSAS - Applying security to a Dimension

When roles are assigned for cubes the user has access or no access to the cube When roles are assigned to a dimension the user gains only partial access to parts of the cube The simplest method of restricting access to a dimension is to prevent access to all levels except the top level of the dimens
 

Tutorial 48: MSAS - Introducing Dimension and Cube Processing

The Analysis server is like a black box Everything that happens in the server is recorded but the end user sees a multidimensional cube created out of the data in the data warehouse and has very little taste of what really goes on behind the scenes In this section we will be examining this black box
 

Sponsored Links

 



About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape