Tell me Wt main advantage of Stage varibles?
Project level hints?
Answer Posted / ramjanaki
The main advantage of Stage Variables is to reduce the
repetition of the code for all the required columns in the
Transformer.
Say for Example, if you are having 10 lines of code to
be used for all the derivations of columns in the
transformer, we declare a Stage variable once and we assign
these 10 lines of code to that variable and can place this
Stage variable where ever needed in the derivation of the
columns in the Transformer Stage. Th scope of these
variables is limited with in the stage it is created.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is the difference between informatica and datastage?
What is "fatal error/rdbms code 3996" error?
in oracle target stage when we use load option and when we use upsert option?
what is the use of skid in reporting?
How to convert RGB Value to Hexadecimal values in datastage?
What is the use of datastage director?
What is the difference between in process and inter process?
How to read multiple files using a single datastage job if files have the same metadata?
What are the steps required to kill the job in Datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Define meta stage?
What are the differences between datastage and informatica?
What are the different types of lookups in datastage?
What is staging variable?
What is quality stage?