You are not logged in.

Problem with load etl of dimensions

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

josekote

Intermediate

  • "josekote" started this thread

Posts: 7

Date of registration: Mar 29th 2012

  • Send private message

1

Wednesday, April 4th 2012, 9:27pm

Problem with load etl of dimensions

estimated
I have a serious problem when you run an etl, I can not my burden is reflected in the Excel and wanted to see if my problem is when I create the etl, what I do first is create 2 connections a relational database sqlserver 2005, which is where I draw my data, and another connection palo to create the dimension and leave my data here. After that I think the extraction of my data (pictures attached), then I think the load (attached image). then run the jobs and I get warnings (attached image), and then to see my size in excel modeller and here I open my bucket filling it with my dimensions loaded (attached image) after hitting out at me and my 4 sizing SQUE I loaded but I go to insert data and I get to 0 (zero) attached images, would appreciate if I can help, any help serves me. Thank you. :)
josekote has attached the following images:
  • 1.JPG
  • 2.JPG
  • 3.JPG
  • 4.JPG
  • 5.JPG

josekote

Intermediate

  • "josekote" started this thread

Posts: 7

Date of registration: Mar 29th 2012

  • Send private message

2

Wednesday, April 4th 2012, 9:30pm

attached images missing

attached images missing
josekote has attached the following images:
  • 6.JPG
  • 7.JPG
  • 8.JPG
  • 11.JPG
  • 9.JPG

konradmai

Master

  • "konradmai" is male

Posts: 54

Date of registration: Apr 18th 2007

  • Send private message

3

Thursday, April 5th 2012, 10:43am

Hola amigo,

you should process the following steps:

Build dimensions:
1. Relational extract for each dimension
2. Build tree for each dimension (i.e. TreeFH)
3. Build one dimension for the facts.
4. Load dimensions

Build cube:
1. Relational extract for cube -> select base fields for each dimension and select the facts
2. Build TableTransform and take the relational extract for cube (step 1) as input.
-> mode: normalize
-> set the dimension for the facts
-> set up the aggregation for the facts
3. Load cube

But you really should read the ETL manual. :)

Saludos,
Konrad

Similar threads

Used tags

dimension, ETL

Rate this thread