Tell me Wt main advantage of Stage varibles?
Project level hints?
Answer Posted / brajesh
1. it can be used as global variable
2. It can be used for some preproceesiing operation
required for some constarint or records(columns).
3.It can be used to store the previous rows processed data
which can be used by next coming row.( its one of the
programming tactic )
Also the order of stage variable matters , it will execute
in the order they apeared on its palate.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the difference between orabulk and bcp stages?
What is the difference between an operational datastage and a data warehouse?
Define APT_CONFIG in Datastage?
Difference between data warehousing and olap?
Can you implement SCD2 using join, transformer and funnel stage?
What are sequencers?
What all are the different way to run a job?
how to abort the job its matain duplicates?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is a merge in datastage?
how to export or import the jobs in .ISX file
I have a few records just I want to store data in to targets cycling way how?
which r the connectors used in san?