DSXchange

I am new datastage can anyone guide me where to write deravations in the pivot stage and what kind of derivation can be wrriten

Please advice

The order of the Stage variables is of paramount importance. The number of keys is not. If the order is as you've listed them above then the "IF" stage variable will never detect a key change. The "current" comes first followed by the stage variable that detects the key change a...

Hi can anyone guide me how to use max function in the stage variable of the transformer.

I dont want to use aggregator for this i wanted to know is it possible to implement in the transformer stage

example:-if input is
1 m
1 m
1 o
1n

Output i am loking for
1 mmon

hi All, I have a requirement in which i have 10 keys columns and i need to perform vertical pivot conversion for the data. Please suggest.. Here is the example INPUT:- AKey BKey CKey DKey EKEY FKEY GKEY HKEY IKEY JKEY SeqNoKEY ADD 1 2 11 a b c d e f g 1 A 1 2 11 a b c d e f g 1 P 1 2 11 a b c d e f ...

Hi All,

I have requirement which i need to transfer two generated .txt files using after job sub rouitne.

One qustion will after job sub routine will help us to get output of the scriptu after passing two files

Hi can anyone please guide me how to open and dataastage generated .txt file to open in external C routine. I am using C routine in Parallel job. I am unable to open the datastage generated .txt file in External C rouitne. If i remove the .txt file from the C routine and hard code the values instaed...

Looks like a problem with the external c++ routine to me. What does this routine do? Copy paste the code here. Thanks Mahadev here is the C code int get_mapping_code ( entry_cd,trans_acct_hist_cd,batch_cd,debit_credit_cd,security_adp_nbr,tran_total_amt,share_trans_qty,desc_sec_line1_txt,desc_trans_...

Hi All, I am using 4 datasets and a funnel stage to join all of them and then the transformer stage calling and external routine(C programming routine) in the stage variable and load into ODBC stage to load in the table. I am getting the below fatal and the job is aborting after inserting new record...

I don't see any mention of compiling and linking your C++ routine, nor any evidence that it compiled successfully and lacked a main() function. ... HERE is the C program Code i have wrriten for the External Routine #include <stdio.h> #include <string.h> int map_code = 0; int get_mapping_code ( char...

ray.wurlod wrote:I don't see any mention of compiling and linking your C++ routine, nor any evidence that it compiled successfully and lacked a main() function. ...

Thanks Ray,

Its my first routine so please guide me if i have missed anythiing.

Its will be greatfull if you give me steps to follow

Hi All, i am developing an external routine in C programing and calling in the transformer stage . I am facing the problem while compling the code. Output from transformer compilation follows: ##I TFCN 000001 03:15:47(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2...

Hi All, I am using a parallel job which uses 4 datasets files as the input which are created in other job . I am merging the four Dataset files using Merge stage and using in the sort stage to sort the data and then through the transformer and finally loaded back to table. I am getting the below war...

Hi All, I am desigining the a server job for extracting of data from the tableA and loading into sequential file.Job finished successfully Next i am calling the sequential file in parallel job and performing some transformation The problem is that i job is finished wiht the warnings as Bad trailing ...

Hi Can anyone please guide me how to open a file and read a file in routines, The routine can be server or parallel routine. The requirement is that i need to take a parameters from the file1 and use it in the routine. the routine need to open the file2 and perform some actions by taking file1 param...

I don't see a problem with option 1, nor a need for any 'looping'. A routine can be used to retrieve the values and called twice in the Sequence, once for each value. Or a UserVariables stage could pu ... thanks for your reply. Can anyone guide me in steps how to follow It will be really helpfull a...