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 / sindhu

row number column in sequential file

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between join, merge and lookup stage?

634


Distinguish between informatica & datastage. Which one would you choose and why?

578


What is apt_config in datastage?

702


Where the datastage stored his repository?

616


What are the functionalities of link collector?

623






what is repositery?

1293


sed,awk,head

966


On which Dimension Table you implemented SCD Type in your Project

1577


how many rows sorted in sort stage by default in server jobs

3554


What is orabulk stage?

630


What are the enhancements made in datastage 7.5 compare with 7.0?

707


Can you explain players in datastage?

703


What is a merge?

668


What are some prerequisites for datastage?

617


How you can fix the truncated data error in datastage?

1191