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
- 8795 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 steps needed to create a simple basic datastage job?
Why we use surrogate key?
What is the difference between hashfile and sequential file?
How to reverse the string using unix?
why do u need the IOS upgradation in a FC switch
What is the use of datastage designer?
Name the command line functions to import and export the DS jobs?
What are datastage sequences?
what is the difference between == and eq in UNIX shell scripting?
What are the main features of datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are stage variables, derivations and constants?
Describe routines in datastage? Enlist various types of routines.
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How do you import and export data into datastage?
