DSXchange

Hi All,

As Roy says processing a fixed length file is faster since you avoid using the functions to remove the demiliters.

Regards
Sreenivasulu

HI,

I remember getting this error. We opened the lock configuration file and tried to change the parameter but it did not work.

We restarted the server. This solved the issue

Regards
Sreeni

HI

You can use the stored procedure to input data to database but if you want to retrieve some value from the database using the stored procedure
then its not quite straight forward. I had once tried to retrieve value using
a stored procedure but could not succeed.

Regards
Sreeni

Yes Sure

Your Yoeman service to datastage and datawarehousing is highly appreciated

HI,

I think UV stage is also used to store all the matching records for a key .
Eg: 1 key having mulitple values

Regards
Sreenivasulu

HI

Sorry. Sending Job designs would violate client confidentiality.

Morever you are new to datastage. Please join a training course

Regards
Sreeni

HI,

I think storing a value of the variable for the next run is not possible
in datastage.

You need to store it in a file or table for reading it in the next run

Regards
Sreeni

HI,

As far as i know range lookup is not possible in hashed file as of now. We
have to go through the database query way as of now

This is one the likely features being implemented in the HAWK release.

Regards
Sreenivasulu

HI,

Please ho through the info for Parallel extender in the forum and those provided along with the software.

Parallel jobs need a differnent configuration namely

1. Separate Software installation for Parallel extender
2. Linking to the compatible C++ compiler
3. Node configuration

Regards
Sreeni

Hi,

I am not sure but i think we can put the normal transformer(not the basic transformer) in a shared container and use it in PX.

Regards
Sreeni

Kumar, I believe the question posed by ravi is with respect to server jobs and not parallel jobs. The change capture stage and change apply stage referred are present in PX. Ravij, Incremental aggregation can be done using a date window for extraction. You load only a particular window's data from t...

Hi,

We use a tool called metacontroller. Its a scheduling tool which reads data from the table.

Now, if you enter the required data in the table the metacontroller triggers the sequence mulitiple times using mulitple parameters.

Regards
Sreeni

Hi ,

Unlike informatica you would not be having workflow for
slowly changing dimensions in datastage.

We need to design the type1,type2 and type3 dimensions on our own way which would suit the requirements.

Regards
Sreeni

Hi, Sudhakar,

Seems You are off to a new year vacation.

Make a Sound when you are back.

Regards
Sreeni

May 2006 be better than 2005 in all aspects of your lives.

Within a blink 2 days of the new year are over

Regards
Sreeni