what is the difference between INROWNUM AND OUTROWNUM IN
DATASTAGE SERVER EDITION?
Answers were Sorted based on User's Feedback
Answer / satyanarayana
INROWNUM generates the rownumbers according to the input
link data where as OUTROWNUM generates the rownumbers
according to the output link data
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / venugopal
INROWNUM counte incoming rows to a transformer stage and
OUTROWNUM counts out coming rows from a transformer stage...
| Is This Answer Correct ? | 7 Yes | 1 No |
why dataset ?
How to transfer file from one system to another system in UNIX?which command to be use?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 Answers Alpharithm Technologies,
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
source file is having 5 records while moving into target it want to be 10 records
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
What modeling tool do you use?
Can you highlight the main features of ibm infosphere information server?