DSXchange

Yes... i've tried similar kind of aggregation and it did work.

Extract the month part alone.
Check if month is 04,06,09,11 then append 30 to the existing string.
Else if month is 02 and (Year%4)=0 then append 29
Else append 31 to the existing string.

The above can be handled using Stage variables in the Transformer stage.

Are there any disadvantages, if we choose RCP in Datastage?

I'm assuming if you say "not working" , the delete records are not coming out of the Change Capture Stage.
If this is the case, inside the Change Capture Stage in the Stage Properties Tab please select the option as "FALSE" for Drop Output For Delete.

I think this is a common problem while using modify stage....Similar kind of problem i've faced while using modify stage...the counts won't be shown but the records do flow and i got the desired output.

I think the work around for this will be to keep only the columns whcih are used as Change Keys (or) Change Values and drop others , and then the output of CDC can again be joined with the after dataset to retrieve all the columns which are required for the second CDC.

Hi,

In the lookup stage, if you select constraints then you can find an option for Lookup failure if that is selected as "FAIL" then if there is no match then the job will fail change it to drop or continue or reject depending on ur need.

Hi,

You can maintain a separate flat file, which will calculate the maximum value and stores in it before running your job, your sequencer can read the corresponding value from the above file created.

Yes i've even tried this out for each parameter value i've repeated -param....... Actually it was working for jobs with just 4 or 5 parameters.......but it ditn waork out with the job having about 17 parameters...!!

One more thing to add is that the number of parameters are more..... Is it due to the length of the command...!!

It says Invalid arguments.... Invalid arguments: dsjob -run [-mode <NORMAL | RESET | VALIDATE>] [-param <name>=<value>] [-warn <n>] [-rows <n>] [-wait] [-opmetadata <TRUE | FALSE>] [-disableprjhandler] [-disablejobhandler] [-jobstatus] [-userstatus] [-useid] <project> <job|jobid> Status code = -9999...

Hi, Im trying to run a job using the option dsjob -run, The syntax followed by me is, dsjob -server <server> -user <UserID> -password <XXXXXX> -run -param param1=value param2=value param3=value param4=value <Project> <Jobname> The error which Im getting is like Invalid Arguments..... When Im trying ...