Interested to Buy Any Domain ? << Click Here >> for more details...
hi this is kiran
i have one table i want divide the table with two different
table like even rows and odd rows
how can i do this one
tell me plzz
- 4 Answers
- 8832 Views
- I also Faced
- E-Mail Answers
Answer Posted / eswar
oracle stage--->surrogate key generator--->transformer
the t/f having 'mod' function
mod(empkey,2)=0 --->even rows
mod(empkey,2)<>0 --->odd rows
empkey is generated from surrogate key generator
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the repository tables in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the types of containers and how to create them?
Explain how a source file is populated?
How to convert RGB Value to Hexadecimal values in datastage?
How will you move hashed file from one location to another location?
What are the features of datastage flow designer?
What could be a data source system?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
which r the connectors used in san?
What are stage variables, derivations and constants?
What is meta stage?
What are the difference types of stages?
In Datastage, how you can fix the truncated data error?
What are some prerequisites for datastage?
