what is the function in Transformer stage can act as Rank
function in Oracle
Answer / prasad
i think there is no function on rank , you can write a sql
query for that one in oracle stage or drs stage/
| Is This Answer Correct ? | 0 Yes | 2 No |
What is a merge in datastage?
which cache supports connected & un connected Lookup
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
how to add a new records into source?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
Terminate Activity
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?
how to design the change capture stage in(data stage parallel jobs) type 2
how can we join one oracle & flat files ?
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
Where the datastage stored his repository?