1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
Answer Posted / pavan
To generate even numbers using transformer, we can make use
of stage variables. declare a stage variable say SV1 and
initialise it to 0. In the derivation of that stage
variable increment it by 2 which looks like SV1+2. By doing
this we can generate even numbers.
mail me @ akellapavankumar@gmail.com for more info.
| Is This Answer Correct ? | 6 Yes | 0 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 ibm datastage?
What are the primary usages of datastage tool?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is job control?
What is the difference between orabulk and bcp stages?
What is the difference between the local container and shared container?
What is difference between join, merge and lookup stage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How rejected rows are managed in datastage?
What is the differentiate between data file and descriptor file?
What are system variables and sequencers in datastage
What are the types of containers and how to create them?