DSXchange

Hi Everybody, When I am trying to run the one of my job,I am getting below fatal errors and getting aborted. Sequential_File_77,0: Output file full Sequential_File_77,0: Failure during execution of operator logic. Sequential_File_77,0: Input 0 consumed 1295395 records. APT_CombinedOperatorController...

The type is 'String' and the values are like: EOD,EFD.

Hi Arndw,

Thanks for the reply..

and "Run_Type_Parm" is a job parameter..Its not a stage variable.

Hi Everybody, When I am trying to run the one of my job,I am getting below fatal errors and getting aborted. 1)APT_CombinedOperatorController(0),0: Fatal Error: Arg to adopt() not null terminated 2)node_node1: Player 8 terminated unexpectedly. 3)nulls={value=first}}}}(0),0: Failure during execution ...

Hi All,

I am getting following error,when i tried to run my job.



main_program: Fatal Error: Source "UNG_SCT_ID" is already kept.

Could any one help me on this.

Hi Thanks for the reply, I have the input flow already in one transformer,so i am planning to implement this(user-defined qry)in a seperate flow. i need to combine thease 2 input transformer (both has the same colflows. and i will map the target column from 2nd transformer flow.(which will have the ...

Thanks ArndW, I am extracting records from 2sybase tables(ex: A,B) based on some extraction logic in user-defined query in sybase stage. I am extracting columns from both the tables.And I am populating in to a TARGET file,after implementing some transformation logic. Now for one of the target column...

Hi Arndw,

Thanks for the reply,If go for funnel,is it possible to select one column from 1st transformer and other column is from 2nd transformer.

If so,In out put mapping window in funnel,how should i map one column from 1st trans and the other column from 2nd trans.

Please reply

Hi All, I am looking for some solution, I have 2 input data flows in my job from same table. But in my out put i need one column is from 1st transformer and the other column is from 2nd transformer. for ex: EMP1---------------> Transformer1 (EMPNUMBER, EMPNAME) EMP2--------------->Transformer2 (EMPN...

Thanks For the reply ray, While doing a Lookup,Can we have field names same in both the tables. In my job I am looking up the same table data. main link column name is as same as reference link column name. I am getting below warning message in my job log: Lookup_22: When checking operator: Dropping...

Hi All, I am getting following errors while Lookup. 1. Lookup_10: Error when checking operator: Unrecognized type-specific format properties: {case=insensitive}; on key "XXX" 2. Transformer_10: Error when checking operator: Could not find input field "YYY". Note:There was a input...

Yes Ray,

I am planning to become a premium member,but what i meant that i asked non premimum members to explain the logic in the similar way,what you mentioned earlier.

Sorry for the confusion.

Thanks

Hi Ray,

Thanks for the reply,since I dont have a premier membership,I am not able to view your full message.

Does some body tell me,what is Ray's reply message.

Hi Everybody, I stuck with to implement some logic in my datstage job. Below is the logic to populate one of my target column 'xxx'. my source table is : SCORPION In that i have columns like 'aaa','bbb','ccc' logic to populate 'xxx'target column IS: If the SCORPION.aaa(primary record) is not NULL th...

Thanks to all, I got the solution,i removed NullToEmpty and Trim function in the earlier transformer stage and i applied If IsNotNull(Link.xxx) Then Link.xxx else If IsNotNull(Link.YYY) Then Link.YYY else If IsNotNull(Link.ZZZ) Then Link.ZZZ Else "" it is working fine. thanks for the help ...