DSXchange

Hi All,

I was trying to generate job by fast track..The idea is to join two tables in fast track...

My doubt is i dont have a target join table in database ..does fast track supports sequential file to store the join result?

And if doesnt support should we have a target table already present in database?

Thank You...

You can store the join result wherever you like. But why not use a Data Set rather than a Sequential File stage? That way your data will retain its partitioning and - if any - sorting.

Ray,

Iam not developing job in designer...Iam trying to create job using information server fast track...(job design is to join two tables)

Can we use seq /flat files as sources and targets in Fast track?....

Thanks for reply...

Thanks chullet,

So we should pre create target table (in my case join table) in database ..right?

And is fasttrack tool available in 7.x version??

Yes. No.

...but it "can" generate 7.5 jobs as a .dsx.....

To enable the DataStage XML export feature perform the following steps for each FastTrack client that has to be enabled:

1.Close your FastTrack client if it is currently running.
2.Open the mozart.ini file that is located at: <information server client install dir>\Clients\FastTrack\Mozart\mozart.ini. E.g. C:\IBM\InformationServer\Clients\FastTrack\Mozart\mozart.ini.
Add the following new line at the end: -Dmslexport=dsx

...this creates the "xml" type of datastage import file.....

Ernie

eostic wrote:...but it "can" generate 7.5 jobs as a .dsx

Which wasn't the question but thanks for pointing that out.