DSXchange

The OP posted the question in a PX forum. Can anyone tell me how he can do this routine in PX? From what I know, in PX, custom routines can only be written in C not Datastage BASIC. Hi, The prallel routines, which are usually call in a parallel tarnsformer is required to written in C language. Befo...

Hi Ajith, I am not pretty sure about your satatement about modify stage. In which document you have read about this performance tips ? even I have some performance documents, they are saying that Modify stage is the more useful stage in the DS Parallel. Until, I haven't find any drgastic performance...

Hi, As per my past expereince, it is always better to utilise the Datastage rather than DataBase queries. In funnel stage, you can use sequential funnel, if your requirement is that, other wise go for continous funnel by default. If you want your data in a sorted manner then go for Sort funnel. If y...

Hi, For scenarios where the number of input rows is significantly smaller (1:100 or more) than the number of reference rows in a DB2 or Oracle table, a Sparse Lookup may be appropriate. I think your condition is opposite, in your case Driving rows are huge and refrence row are less. So, It will defi...

Hi,

No document will give you the details of full error messages and warnings. You have to analyse the error message and warnings from the director logs. DSXchange will be helpful to identify, different type of errors, warnings and their solutions.

Hi Aparna,

Please go through this link, you can get very clear idea about Reject handling.

http://blogs.ittoolbox.com/bi/websphere ... akage-7169

Thanks Ray, It is a good information. Sorry for posting it as server. Where can i find plenty of documentation or information related to this nodeconfiguration and Creating config.apt files. Please help me if there is any books or articles related to this. Thanks in advance. Hi, Regarding Documenta...

Hi, If you are handling the nulls in the transformer it self, then make it nullability to NO in the transformer itself. then there is no need to change in the sequential file. If you want the target field as nullable Yes, then You need to set the Null Field Value property (from the Edit Row dialog) ...

Hi All, Final Conclusion from this disscussions is , it is not possible to trim leading and trailing spaces by using Modify stage. It is possible only through Transformer stage. So, can I ask DS gurus, can we ask this functionality in the next release of datastage to IBM. If the above conclusion is ...

Hi, If your input data is coming from a database, first perform order by to group the data based on keys number and Good or Bad key and after that use the sort stage and select the keys and select the option Don't sort if previously grouped and change the settings of Create cluster key change column...

Hi, What is the length of the target field UPD_DATE. If you use TimeDate() function to handle null . It will generate the time and string in the format : %yyyy-%mm-%dd %hh:%nn:%ss, It is total length of 19 charcters. Now, as per my analysis, what I am thinking is your Target filed UPD_DATE length is...

hi all, how to calculate the "Age of a person" or "difference b/w dates" using the datastage functions ThanksinAdvance Boppana Krishna Difference between dates can be found by converting the dates to Julianday and finding out the difference between them. But then finding out the...

Hi, We can acheive your functionality by using funnel stage. If you perform sort funnel. If you want the result in the mentioned order in the sequentail manner. Select the execution mode as sequential and collect that by using sort merge method of collection. Because paralell sort will sort the data...

Hi, I got to know from the previous postings by Rhys Jones that it is not possible to connect to Db2 databases on OS 390 machine using DB2 EE stage. Since am looking at doing the extraction of records from different partitions in parallel, Does that mean that it is not possible to extract records i...

Hi, To get the accurate results, It is always better to sort the data and at the same time perform HASH partition also. One more thing here you can include is using of environmental variable APT_SORT_INSERTION_CHECK_ONLY. For stages like join, datastage will insert Tsort operaor. It will happen, eve...