abt sql overriding
Posted: Mon Dec 11, 2006 9:02 pm
hi,
one of my mate always compares datastage with informatica.
he says that he can override the sql statements at session level and at mapping level.
i said that u can specify a sql statement in the where tab and if u want one can overide the specified sql statement using a jobparameter.
he asked whether u can use jobparameters in source stage and in transformation stage.
i said yaa we can browse for jobparameter in source stage and in transformation stage.
we can even browse for jobparameters in sequencer.
i want to know is there any option to override the sql statement in jobsequnce, how can we do it.
plz correct if i went wrong.
cheers;
vijay
one of my mate always compares datastage with informatica.
he says that he can override the sql statements at session level and at mapping level.
i said that u can specify a sql statement in the where tab and if u want one can overide the specified sql statement using a jobparameter.
he asked whether u can use jobparameters in source stage and in transformation stage.
i said yaa we can browse for jobparameter in source stage and in transformation stage.
we can even browse for jobparameters in sequencer.
i want to know is there any option to override the sql statement in jobsequnce, how can we do it.
plz correct if i went wrong.
cheers;
vijay