Hi I have scenario like this
s/r table T/r table
ename,sal empno,ename,sal
vijay,2000 1 , vijay, 2000
kumar,3000 2 ,kumar , 3000
ravi ,4000 3 ,ravi , 4000
How can i get target table like that without using
Transformer stage?
Answer Posted / srinivasu
This is an optional property. It adds an extra column of type unsigned BigInt to the output of the stage, containing the row number. You must also add the column to the columns tab, unless runtime column propagation is enabled.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do y read Sequential file from job control?
What are the types of containers?
Define project in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
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?
What is the difference between Datastage 7.5 and 7.0?
Explain the situation where you have applied SCD in your project?
What is merge stage?
Differentiate between odbc and drs stage?
What is a datastage job?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Explain connectivity between datastage with datasources?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Lookup constraints
What a datastage macro?