DSXchange

Hi , Thanks for your suggestion. The job is working fine after the modification in the schema file.But I am unable to see the content of the sequential file. 3 Records are coming from the source and I am unable to see the records in the Output.In the sequential file stage the RCP Property is checked...

Hi, My PX job contains Oracle Stage --> Transformer ---> Sequential file stage.In the Oracle stage I am using the RCP so that the columns are propagated up to Sequential file.In the sequential file I am using the schema file for meta data.The schema file is as follows. (record name:string[255]; BPH:...

[quote="Maveric"]Think of a multi instance job. determine the range of values in the source data. Give the range in the SQL where clause. Probably pass the where clause as parameter or the SQL statement as parameter.[/quote] Hi , Actually here the requirement is I have to run the Same job ...

Hi , I am having one requirement based on the Source Size I have to load the Data in to target.For each run I have to execute the job. For Example My Source table size is 100 MB then I have to run my Job for 10 times and each run I have yo load 10MB data in the Target table. If the job fails in the ...

Hi , My requirement is I am getting 3 source files with same meta data and I have to design one job in that I have to load these files one after the other.In the Target table I have to append the Seconefile Data to the first file and so on.. While reading the first file if i encounters any problem t...

Hi ,

I am getting a String as 'data',as per my requirement I have to load in to the target as 'atad' in the reverse order.The lenth of the input data is not constant.

Can some one help me regarding this?

Thanks and Regards
Siva

Hi , I saw some IBM related website there they mentioned How to work with XML files in server job,For that they have used Folder stage.From this folder stage they are connecting to XML input stage.But when you open the PX job this stage is not present in the Pallet.So how to read from the XML files ...

Hi , I design a job with reject table For a look up stage.In first run the reject table contains say for example 20 records.As per the business requirement i have to truncate the table before the 2nd run of the job and also I have to process the reject records as source. So when i use the same table...

Hi , I am creating the Top Job Sequence ,it contains the Exception activity and Notification component. This Top job Sequencer calls the child sequencers and the child Sequencers calls the Datastage jobs. As per my requirement if the job fails in any of the child sequencersthen I have to capture the...

Hi , I have to create a surrogate key for a target table by taking the maximum value from the same target table. For example I get the Maximum value as 100 now I have to insert the values starting from 101 for this I am using the Transformer stage for incrementing the values the Logic is MAXVALUE+IN...

[quote="ArndW"]Siva, I have already stated that "yes, it is possible". Since you still haven't answered the question as to what database you are using nobody can help you much further. The DS/BASIC routine will c ...[/quote] Hi, In Our Project we are Using the Oracle Database and...

[quote="shivakumar"]Hi, We are using the Server Routines in the Parallel Jobs. As per our requirements we have to Load the Job Statistics in to the Database Tables. Is it possible to Insert the records in to the Tables From the Routines. If So then please help me regarding this. Thanks and...

[quote="shivakumar"]HI, I am getting the records from the Source table and after doing the Look up with target I have to Insert the New records and also the Updated records in the Target table. If i Use the Change Data capture Stage Or Difference stage then it will gives the Updated record...

Hi,

We are using the Server Routines in the Parallel Jobs. As per our requirements we have to Load the Job Statistics in to the Database Tables.

Is it possible to Insert the records in to the Tables From the Routines.

If So then please help me regarding this.

Thanks and Regards
Siva

HI, I am getting the records from the Source table and after doing the Look up with target I have to Insert the New records and also the Updated records in the Target table. If i Use the Change Data capture Stage Or Difference stage then it will gives the Updated records onlyin the out put,but I hav...