DSXchange

How can we compose a If then ElseIf then else statement in a EE transformer. It allows me if I use a single If then Else stmt but not if I tag on ElseIf in to the condition. This is what I am trying to do If Flag='X' then 'Count' else if Flag='N' then 'Deduct' else 'Processing' Thanks for looking in...

Hi ,
Thanks for the reply, looked at it, and tried to develop a PX job which stores the value into a stage variable, and I am struck on how to retrieve this a s user status or parameter for the next job in a job seq.

Appreciate your help

Hi,
I am calculating a date value in Job1 , now I need to pass this value to Job2 (as a parameter so that it can be used in the join condition) without landing the data into a dataset or table, can I acheive this using any stages in the sequencer ?

Thanks,

Hi,
I had this seq run before and the param name it is complaining about still exists in the user defined varaibles!

Hi,
I had a job sequence that used to run fine, now it aborts with the following error :

..JobControl (@JobName): Controller problem: Error calling DSSetParam($DIRECTORY), code=-3
[ParamName does not reference a known parameter of the job]


Any ideas?
Thanks,

Hi, Thanks for the time, I have set the field to Yes for the "Nullable" column. Now I write the output to a copy stage and after which I have a transformer where i do the following If In.Col='NULL' then '2' else '1' It just drops the column ! APT_CombinedOperatorController,0: Field 'RR' fr...

If the lookup fails I need 2 as output.

If lookup doesnt fail then 1, if lookup fails then 2.

Thanks,

Hi,
I made the field nullable and now it rops the column with the error NullHandler,0: Field 'CDE' from input dataset '0' is NULL. Record dropped.

I am searching the forum, looks like there are few postings.
Thanks,

My job desing is : OracleStage | | Source (Oracle)--->LookUpStage----->DataSet If the source row doesnt match , it is just returning a space and I have it as not nullable and continue option in the lookup stage constraints. How can I get it to insert the word NULL if the lookup fails ! Thanks

Hi Ray, Hey finally got to see you on this website! So I have a Oracel Stage then a lookup Stage and now do I need to add another modify stage (or a transformer) after the look up stage. In the modify stage I can set the default value if it is null , but the look up stage writes NULL so the field is...

I have a situation where if the source rows match the lookup rows then need to push 1 as the result ,else as 2. In the lookup stage conditions if I use continue for both the columns "Condition Not Met" and " Lookup Failure " , it says, if the source records DO NOT MATCH the looku...

I have a situation where if the source rows match the lookup rows then need to push 1 as the result ,else as 2. In the lookup stage conditions if I use continue for both the columns "Condition Not Met" and " Lookup Failure " , it says, if the source records DO NOT MATCH the looku...

Hi,
When we import column definition, and load into a OCI stage, the columns come across as Unicode in the extended column.

Is there a way to avoid than changing it manually.

Thanks,

Hi, I am writing to an Oracle table, if I use the option "Upsert" the job completes fine and loads around 200K records. If I use Load with Truncate option, it gives me this error "main_program: Fatal Error: Invalid character encountered in table TempTable" Any one with ideas, Tha...

Hi Need to read a value from a timestamp / date column and load the max value to varchar. Have used modify stage with the following conversion string_from_timestamp[YYYY-MM-DD HH24:MI:SS](In.DateColumn) Getting error main_program: Error parsing modify adapter: Error in binding: Error in destination ...