DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
taslimanka
Participant



Joined: 25 Jun 2017
Posts: 2

Points: 34

Post Posted: Tue Sep 05, 2017 2:00 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi all,

I'm a DS newie so excuse my questions. In fact I'm using 2 oracle DB instances.One for input and the other for target table. I just want to query on the first DB and then write the result on the second one. But it seems that with my query (which return about 35 columns) I have to type in all of the columns (with their type). I dont want to write the target table's schema by typing in all the input columns in the OCI stage. Is there any way for DS to fill in from my sql query the list of input columns?
Thanx in advance.
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42216
Location: Denver, CO
Points: 216757

Post Posted: Tue Sep 05, 2017 3:27 pm Reply with quote    Back to top    

You should be importing the metadata for your source and target, then loading them into the stage, that way you don't have to manually type them in. And then yes, the source stage can automatically generate the SQL at runtime from the metadata. I have no DataStage access and it's been way too long but the 'action' to accomplish that should be fairly obvious. I'm sure someone here should be able to help with the specifics if you can't find it.

Can you verify, please, that we are actually talking about a Server job?

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54035
Location: Sydney, Australia
Points: 293134

Post Posted: Fri Sep 22, 2017 3:37 am Reply with quote    Back to top    

CompactBI offer a bridge that will analyze SQL and convert into metadata in the Information Server metadata repository. But importing the table definitions (or view definitions) from Oracle using ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
UCDI



Group memberships:
Premium Members

Joined: 21 Mar 2016
Posts: 267

Points: 2686

Post Posted: Fri Sep 22, 2017 12:51 pm Reply with quote    Back to top    

while the correct thing to do is import the metadata, this will help you for intermediate jobs where the metadata isnt in any database.

you can write a dataset from where-ever in your job and import a table def from that by going import, table defs, orchastrate and choose the dataset file. Save the table def and drop it on the link you need.

You can do this from a source or target system also but again, those should be imported correctly so this would just let you get around it for a quick fix until you can learn the correct process or get an admin to do it for you (where I am we can't do this, its governed by someone outside the developers). Just make a job with select * from / get 1 row, drop to dataset and pull the metadata off that.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours