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 / pavan
Hi This is pavan u use surrogate key generator.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How can we improve the performance in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is data partitioning?
How can one find bugs in job sequence?
How many types of views are there in a datastage director?
What is datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
Why do we use link partitioner and link collector in datastage?
Differentiate between odbc and drs stage?
sed,awk,head
How the ipc stage work?
Define Merge?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Define ds designer?