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?
- 8 Answers
- 11210 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / surya
you can generate surrogate key in the transformer itself.
right click on the stage variables. tre you can find surrrogate key.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are iconv and oconv?
Terminate Activity
How a routine is called in datastage job?
What is the use of hoursfromtime() function in transformer stage in datastage?
Can you explain repository tables in datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Define Job control?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What could be a data source system?
Which warehouse using in your datawarehouse
Can you explain kafka connector?
Distinguish between informatica & datastage. Which one would you choose and why?
what is the use of materialized view?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the different type of jobs in datastage?
