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 / d
d
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How many types of views are there in a datastage director?
Can you implement SCD2 using join, transformer and funnel stage?
What are the stages in datastage?
Can you explain players in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
How to Remove Duplicate using SQL?
What are the different types of lookups in datastage?
what is the use of surogate key in datastage
How can one find bugs in job sequence?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Have you used Unstructured data?
What are the job parameters?
How to reverse the string using unix?
What is the purpose of interprocessor stage in server jobs?