Modify Stage Dynamic Specifications
Posted: Tue Feb 07, 2012 2:38 pm
The article "how-to-become-a-modify-stage-zen-master":
http://it.toolbox.com/blogs/infosphere/ ... ster-20368
says "The Modify Stage is overloaded with specifications - it has 20 specification job parameters that are all set to blank and it will only run the ones that you populate at run time."
I tried to achieve this functionality using a string job parameter in the specification and not setting a value for it (blank) - It didn't work.
My job has column generator, modify n oracle target.
4 Specifications using job parameters in the modify stage,
3 input columns all varchar(10): Col_1, Col_Rename, Col_3 and Col_4
I kept 3 columns, renamed one in the modify
and wrote them to target that has 3 output columns: COL_1, COL_2 and COL_3.
RCP is on and no columns defined on the columns tab of modify or Oracle enterprise stages.
I got:
Error Parsing Modify Adapter. Error in binding. Expected destination destination field selector, got: ";"; input:
KEEP Col_1, Col_Rename, Col_3
;
Col_1=COL_1
;
Col_2=Col_Rename
;
Col_3=COL_3
;
;
[sil/step_il.C:3442]
Without the last blank specification the job runs fine. But if we have a requirement for adding an extra columns at run time, we need to have blank specification in there - am I even interpreting the article correctly?
I tried setting Col_4 to itself i.e. Col_4=COL_4, but kept only 3 columns and that worked. But still my step does not match with the article.
Can someone please shed some light on this?
Thanks
Gary
http://it.toolbox.com/blogs/infosphere/ ... ster-20368
says "The Modify Stage is overloaded with specifications - it has 20 specification job parameters that are all set to blank and it will only run the ones that you populate at run time."
I tried to achieve this functionality using a string job parameter in the specification and not setting a value for it (blank) - It didn't work.
My job has column generator, modify n oracle target.
4 Specifications using job parameters in the modify stage,
3 input columns all varchar(10): Col_1, Col_Rename, Col_3 and Col_4
I kept 3 columns, renamed one in the modify
and wrote them to target that has 3 output columns: COL_1, COL_2 and COL_3.
RCP is on and no columns defined on the columns tab of modify or Oracle enterprise stages.
I got:
Error Parsing Modify Adapter. Error in binding. Expected destination destination field selector, got: ";"; input:
KEEP Col_1, Col_Rename, Col_3
;
Col_1=COL_1
;
Col_2=Col_Rename
;
Col_3=COL_3
;
;
[sil/step_il.C:3442]
Without the last blank specification the job runs fine. But if we have a requirement for adding an extra columns at run time, we need to have blank specification in there - am I even interpreting the article correctly?
I tried setting Col_4 to itself i.e. Col_4=COL_4, but kept only 3 columns and that worked. But still my step does not match with the article.
Can someone please shed some light on this?
Thanks
Gary