DSXchange

Thanks for your response!!

I will keep this topic open for one or two days until I mark this as Resolved. I would like to know some other approaches for this design.

Hello All, In need your advice on something I'm working on. I need to create an Job sequence in the DataStage project A but this needs to trigger a job which is in the DataStage project B. At present I use to do this putting a flag in a table and I have a Unix Shell that looks for the flag and execu...

Finally the person who provide me with the files changed the column delimiter to TAB delimited.

thank you for your advices and suggestions!!!!

Regards!!

There are some standards under our BI department which specified that no UNIX commands can be used to transform data in the ETL process. It includes filter commands under the Seq file stage. I can't use Trim function because some data include leading spaces which are required. I think that I will cr...

Hi All, I need to read a sequential file which is delimited as "space + TAB + space". The Hex code for space is 020h and for TAB is 009h. I don't know how to specify this kind of delimiter in the Sequential file stage under the delimiter text box in the format tab. Any advice?? suggests ar...