Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between INROWNUM AND OUTROWNUM IN
DATASTAGE SERVER EDITION?
- 2 Answers
- 19703 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Can you explain repository tables in datastage?
What is difference between join, merge and lookup stage?
How you Implemented SCD Type 1 & Type 2 in your project?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How to perform incremental load in datastage?
How many types of hash files are there?
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?
Have you used Unstructured data?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How can you write parallel routines in datastage PX?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
