Oracle Analytics Cloud and Server

Products Banner

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

  • Brian666H
    Brian666H ✭✭✭✭✭

    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