Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

DATASYNC LOAD TABLE (DIM) NOT USING SQL

Received Response
21
Views
1
Comments

Summary

How do I add a new dim table, full table, Dim

Content

I know how to add a table using SQL.  but I understand that I should be able to reference a single table and pull it into DataSync.  From PSOFT to the Cloud

Version

18 , Cloud

Capture.JPG

Answers

  • Rank 6 - Analytics Lead

    I worked it out.

    1. From Project/Data Flows Click NEW
    2. Import Definition Click Discover object from Catalog.
    3. Within the filter Box enter your table name and Click Search
    4. Select Table and click Import Definition
    5. Click IMPORT
    6. OK

Welcome!

It looks like you're new here. Sign in or register to get started.