DSXchange

Hi Please help me in solving this problem. I have a job which has sort stage and remove duplicates stage and surrogate key stage. Iam sorting on validfromdate which is char[8] and removing duplicates using Remove duplicate stage and Iam using hash partition and iam using surrogate key for generating...

Hi Williams,


Thanks for solving my another problem







Thanks,
Somaraju

Hi, Please help in solving this problem . Iam getting a warning message like this Rmv_VFD_Cbl: When checking operator: User inserted sort "Sort_VFD_cbl" does not fulfill the sort requirements of the downstream operator "Rmv_VFD_Cbl" I have a job which has sort stage connected to ...

Hi Arnd, Actually when Iam defining a metadata for sequential file. I gave total columm metadata length as 187 and after seeing your post I checked all the lengths of the columm then I got 187 total length . I added 2 more bytes to the last columm metadata which is free space and now it was 189. The...

Hi Arnd,


Thanks for solving my problem .









Thanks,
Somaraju

Hi, I need help in solving warning messages. I have a input file when Iam reading data from that input file Iam getting a warning messages like this Sequential_File_0,0: Import consumed only 188bytes of the record's 189 bytes (no further warnings will be generated from this partition) Sequential_Fil...

Hi Kumar,


Thanks for your help in solving my problem.








Thanks,
somaraju

Hi, I need a help to over come warning message. I have a job when Iam running that job Iam getting a warning message Surr_Key_Ann: When checking operator: When binding output interface field "AnnNumber" to field "AnnNumber": Implicit conversion from source type "int32" ...

Hi williams,

your logic worked thanks for your help in getting out from this problem




Thanks,
srinuraju

Hi Kumar, My Actuall requirement is to get min value from (ValidFromdatecolumm) Ex I have dates like 19942008 19942004 19942004 19800205 I want 19800205 as my output which is minum value and I used sort stage and remove duplicate stage but Iam getting min values for each duplicate values. I want min...

Hi Williams, Thanks for reply, Let's see if I've got this right. Please correct me if Iam wrong. I have to create a static columm dummy in aggregator stage output and I should assaign all the input rows validfromdate columm to dummy columm. Then I have to sort in aggregator with dummy and validfromd...

Hi armachandra,

Can you explain in detail how to sort and get min Validfromdate.




Thanks,
Somaraju

Hi, Please help me in getting out from this error . My input has a validfromdate columm with SQL Type is char and length of that field is 8. When Iam using an aggregator Stage for calculatng Min(validfromdate). Iam getting an error Aggr_Min_VFD: Error when checking operator: It is not legal to set a...

Hi, Actually the requirement is, there is a java application and if we want to invoke a datastage job from java application is it possible. ex: there is a java application PRT and a message is sent through that application and according to that message datastage job has to run.Is there any stage tha...

Hi,


Can any one tell me wether I can run my datastage jobs using Javascript.
Is there any option in datastage.If there is a option please let me know.


Thanks,
Somaraju