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
- 8973 Views
- I also Faced
- E-Mail Answers
Answer Posted / nish
You could also go for a column generator and cycle the values 1,0.
then filter based on this column.
It will be much faster then employing a transformer stage having to generate @rownum and then do a mod calculation.
Trying to reduce the number of transformer stages is a key efficiency best practice.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe stream connector?
What are the various kinds of containers available in datastage?
What are the stages in datastage?
How will you move hashed file from one location to another location?
On which interface you will be working as a developer?
What are the main features of datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What is ibm datastage flow designer?
Could anyone give brief explanation bout datastage admin
Have you have ever worked in unix environment and why it is useful in datastage?
Where do you see different stages in the designer?
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
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Difference between in process and inter process?
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
