DSXchange

Hi

In DS Server we have First,last,Avg functions available in Aggregator stage.

what are the corresponding functions in Parallel Aggregator stage

Thanks

The data is actually having a vertical tab.How should I handle this

Hi

I have following columns
X CHAR(32)
Y CHAR(5)
which should be converted to a delimited file
X "\013"

Y "\013"

\013 refers to Control K delimiter.Please let me know as how to Proceed.

It is like columns may be seperated byPipe demiliter .And I have to reject records having greater than 2 decimal places.Can I implement both when I read the records without using a transformer.

Hi

I have file which is of this format:

|0.2

Meaning it has | delimiter or it has decimal data with 2 digits after decimal.For example

100|100.02|77|

If it has data100.023 it should go to reject file

How can I deal such scenario.Please help

Thanks Arndw for your reply

Thanks Arndw.Can you please give me more details with regard to close command.

Yes.It should be a after job subroutine.Since my after job subroutines is to collect logs...Can I have a wrapped stage/External Target after my target table...

Thanks for your reply.It should be executed once per job

Hi

I want to execute shell script.There are 2 ways to execute

a.Using Execute Command stage

b.After/Before job routine

My scenario is I cant use Execute command stage.I already have another after job subroutine to extract log.

Can I use External Target?

Please help.Thanks

Hi

I have a database x in which i have many schemas.I have table Y.

I refer table Y in the following format:

X..Y in the database component of Sybase.

(I was using this format in the ETL Tool from which I migrating to Datastage)


Will the same format work in datastage as well?

Thanks

Shell script is called from Control M .After the execution of sheel script my datastage job is run

Thanks Arndw..

My flow is like this:

shell script(set environment variables) -----> Access them within job

is there any work around...

Hi

Is it possible to set datastage environmental variables using shell script.If so,how should I proceed

Thanks

Hi

Is it possible to pass 2 parameters to After job subroutine.If so how Should I dot it?When I give comma inbetween 2 parameters,it gives wrong output.

Please help

Thanks.