Interested to Buy Any Domain ? << Click Here >> for more details...
1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
- 5 Answers
- 15044 Views
- Gallega, TCS, I also Faced
- E-Mail Answers
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
What is job control?
what is repositery?
How do you import and export the datastage jobs?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are the types of jobs we have in datastage?
What are the different types of lookups in datastage?
sed,awk,head
Explain usage analysis in datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Define Merge?
What is difference between join, merge and lookup stage?
What is a merge in datastage?
Differentiate between datastage and informatica?
