DSXchange

ray.wurlod wrote:I'd bet Char(8) - am I right? So you can only get eight characters in that field. ...

char(12) on either ends(in source and target as well)

ulab wrote:

ArndW wrote:The transform function Right('000000000000':In.AD-ACCT-ID,12) on a string. ...

Char data type

The transform function Right('000000000000':In.AD-ACCT-ID,12) on a string. ... from the above statement, this one is not giving the results as expected, but in fact the out put is as below in bold c1 AD-ACCT-ID c2 c3 @ 10296505 000000 000 000 the bold 8 characters are the output of the field AD-ACC...

The transform function Right('000000000000':In.AD-ACCT-ID,12) on a string. ... from the above statement, this one is not giving the results as expected, but in fact the out put is as below in bold c1 AD-ACCT-ID c2 c3 @ 10296505 000000 000 000 the bold 8 characters are the output of the field AD-ACC...

Hi Friends, Am new to Data stage, am looking for a logic which can fill '0'(zeros) at the left side of the input colomn value, just as below FromTable, ToColumn, Type, Length, Formating uniquename, AD-ACCT-ID, 9(12), Numeric, 12, Left Zero fill, force to field length I have done a search but could n...

Good Day All, Am using a lookup stage and tring to load data from a Seq.File1 with a lookup of Seq.file2 and the target is also a Seq.file, but the data is not loading, its giving the following warning message " When checking operator: On output data set 0: Dropping component "VendorNumber...

am a beginer for DS please suggest me the solution in detail please, parrel job am getting the following warning and data is not loaded into the seq file "Join_PO_Amt_Line.InTo_Join_POLine_Sort: When checking operator: Operator of type "APT_TSortOperator": will partition despite the p...

Good Day All, am a fresher to DS, in my production job the data is struck at Trns_stage with a warning "APT_CombinedOperatorController(1),0: Field 'POLINEAMOUNT' from input dataset '0' is NULL. Record dropped." and after that data is not loaded into the target Seq File.Please help me to fi...

Good Day All,
"APT_CombinedOperatorController(1),0: Field 'POLINEAMOUNT' from input dataset '0' is NULL. Record dropped." this is the warning message for 28 colomns and no record is loaded into the target Seq_File, could you Please help me in solving this problem.