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
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How a source file is populated?
what is the use of skid in reporting?
What are stage variables, derivations and constants?
What is a ds designer?
What is datastage engine?
Describe routines in datastage? Enlist various types of routines.
Why we use surrogate key?
how to add a new records into source?
How many Key we can define in remove duplicate stage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are the different plug-ins stages used in your projects?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the different layers in the information server architecture?
Explain entity, attribute and relationship in datastage?