Forum Stats

  • 3,838,758 Users
  • 2,262,398 Discussions
  • 7,900,750 Comments

Discussions

Categories

Multiple values in a variable

561241
561241 Member Posts: 187
edited Oct 27, 2008 4:13AM in Data Integrator
I wish to store the records of employee table which has multiple columns and multiple records in it. How can I do that with ODI variable ?

EmpNo EmpName Design
1 E1 Software Engineer
2 E2 Software Engineer
3 E3 Senior Software Engineer

Edited by: user558238 on Oct 16, 2008 3:03 AM
Tagged:
· Share on TwitterShare on Facebook

Answers

  • Shamil
    Shamil Member Posts: 181
    edited Oct 16, 2008 6:22AM
    ODI variable has a refresh option to put a query in it.

    BUT

    why would you need that? why not to store records in a table?
    · Share on TwitterShare on Facebook
  • 626704
    626704 Member Posts: 214
    Hi,

    You can use a ODI refresh variable, but some limitations in that refreshing query.

    Refreshing query should return an single row as well as single field (If you need all the fields of a record means you must append the all the fields into a single field.Then only that variable will works.

    Thanks,
    Madha
    · Share on TwitterShare on Facebook
  • 656835
    656835 Member Posts: 15
    Hi,

    I think that the Shamil's idea is the best. You can create table in the Sunopsis Engine technology. It's like a database built into the ODI. For now there are some system tables which ODI needs, but you can create some tables for your own.

    Also if you want to store more complicated structures you write a class in Jython language and use it as you wish. I recommend Jython, cause it's really powerful tool in ODI as you can add any Java class you like.

    Good luck.
    656835
    · Share on TwitterShare on Facebook
  • 561241
    561241 Member Posts: 187
    If I am using Oracle database (all my source , staging and targets are on Oracle), can I use the Sunopsis Engine technology ?
    · Share on TwitterShare on Facebook
  • Shamil
    Shamil Member Posts: 181
    yes
    · Share on TwitterShare on Facebook
This discussion has been closed.