DSXchange

Assuming I have one sequence job which is triggering one parallel job. In the parallel job I have four parameters and all the parameters have been mapped through the sequence job. Now let say I have removed one parameter from the parallel job and consider the below two scenario. 1. Compiled the sequ...

I am using a DB2 connector for extraction data from a large DB2 table. If I use partition read and set generate sql(for partition read) to No then the query looks like the following: SELECT COL1,COL2,COL3 FROM SCHEMA.TABLE WHERE NODENUMBER(COL2)=CURRENT NODE. Considering COL1,COL2 composite primary ...

If both source records and lookup records are coming from tables then you can perform the whole operation in the query level while extracting from the source.

Thanks Ray for your valuable inputs.

If I want to achieve this using combine records stage,is it possible to meet the functionality?

I have read on restructure stages(combine stage,subrecord stages, vector stages) in developer guide(IBM) and also in the various sites, but didn't get any clear idea about how to use these. I want to use these stages in the following scenerio. Input records: COL1 COL2 1 A 1 B 2 C 2 D 3 E 3 F 4 G 4 H...

Thanks all for your reply.

@Ray : Datatype I have used as Integer

@Chulett : Everywhere I have used Datastage sort . I was reading about psort and tsort, then I have tried this by developing sample job and saw the difference.

I have created a simple datastage job which performs the following. 1. Prepare data using row generator stage(10 integer records starting from 1 to 10) with only one column COL1 2. Perform a sequential sort using a sort stage(descending sort) 3. Write the records into a text file. I have used sort u...

In DB2 connector settings there is one settings as Load Mode if I set it to bulk load. There are the following options available for this setting.

1. Insert
2. Replace
3. Restart
4. Terminate

What is the use of these settings and how this can be used with the available options.

In place of @INROWNUM can you please try with @OUTROWNUM

Can the column name be different in the table and it's corresponding exception table in db2 when preforming bulk load? I have one table A with the following columns COL1 COL2 COL3 And in the exception table COL11 COL22 COL33 with the same metadata and nullability as of the above table. Datastage Ver...

What is the aggregation method you have used?
I guess you have used the sort method. If that is the case then I think it is required to sort the input data to the aggregator on the basis of aggregation keys with the same order of the aggregation group.

Thanks a lot ArndW for your suggestion. Surely I will keep in mind your suggestion when I will do the checking.

When I 'm partitioning in the input then same key combination records will be in same node,it doesn't depend on the sort. So is it something like that it will join not by the value directly but with some other means.That's why sorted order is mandatory in both the links. I will also try one thing. I...

I am joining two table in the datastage join stage. I did hash partition on the join key in both the link. And by mistake I forgot made in line sort in one of the link. In this case for the matched records also the join did not happen properly. But when I made the in line sort then it worked fine. S...

Thanks a lot for your reply.

I have one file where no of columns are fixed -using Pivot stage

I have one file where no of columns are not fixed - using transformer loop stage