DSXchange

Ray,Single source cannot be use with change capture stage.
either Query,Sort or remove duplicate stage can be used for this solution

Design seperate jobs for each dataset and write into file. i wonder how the datasets are created in one project but by using different config files. Is the datasets created on same project? we can do by passing $APT_CONFIG_FILE as parameter and read the datasets into sequential file and combine both...

Your Datastage version may be differ for the above problem.

Instead of the posted code try using this code and compile.

Consider you are writing datasets called A(Config File1) and B(Config File2) First Config File. DataSet Data files are created on both dsserver1 and dbserver1 Second COnfig File. First Config File. DataSet Data files are created on both dsserver2 and dbserver2 When reading the Dataset files you shou...

Code a User defined Query to query only the required records.
This will minimize the processing time.

Code a User defined Query to query only the required records.
This will minimize the processing time.

The project name and Jobname can be passed through DS Macros.

Execute the script using Execute Command Activity Stage and Pass the required parameters.

Derive the project name and Jobname prior to the Execute Command Activity.

Exception activity-------> Job Activity(Status Update Job in Table)........> Terminator Activity for Failed Jobs. For successfull completion. Call Job Activity(Status Update Job in Table) at end of the activity. so your design will be like below. Job Activity(Actual Job)--->Job Activity(Status Updat...

have a stage variable Mod(AsInteger(input column),2)

i will retun 1 or 0

1=True means Odd rows
0=False Even records

in Constarint specify StageVar=1 in first link.

in Constarint specify StageVar=0 in second link.

Input data

4456456.6456
12312.423
5534.64565
312123.567887

the scales are not fixed here. it may or may not exceed.

How can i read those values and load into database.

in database decimal[20,10]

how can i read this

is there any possibility using Modify stage.
But the columns should not be hard coded.
suppose if i want to sum 100 columns(existing columns) and introduce a new column for the output value.

how can i do this in Schema file and RCP scenario.

need to add dynamically

additional columns may be added in future.

Col1 Col1A Col1B Col1C Col1D Col1E

i have below input

Col1 Col1A Col1B Col1C

ABC 10 10 10

CDE 10 10 10

EFG 10 10 10

Need output like below

Col1 Col1A Col1B Col1C Col1_SUM

ABC 10 10 10 30

CDE 10 60 10 80

EFG 10 20 10 40

why dont you use simple SQL query to delete the records in DatabaseA which is NOT IN DatabaseB.

create a sequence like this ExecCommand-------LoadJobActivity-----ExecCommand-=---ExecCommand First echo a header to the filename i.e header>Filename In Job Activity Stage create a temperory Detail File. third Stage Move concatenate header file into the header file fourth stage create a footer recor...