Join in FastTrack

[allavivek]

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...

[ray.wurlod]

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.

[allavivek]

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...

[chulett]

No.

[allavivek]

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??

[chulett]

Yes. No.

[eostic]

...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

[chulett]

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

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