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?
Answers were Sorted based on User's Feedback
Answer / ramachandra rao
first of all question is not clear
ok fine
if u take source as sequential file there is one option is
there i.e rownumcolumn use this option it will create
sequnce number.
2.use columngenerator also we used
Thanks
chandu-09538627859
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
Answer / krishna evsg
Hi Vijay
Actually I don't Know Transformer stage, But we can do the
above scnario in SQLSERVER2005. In SQLSERVER2005 we have a
built in function for Row_Number().
create table Source_Tab
(
ename varchar(max)
,sal money
)
GO
create table Target_Tab
(
eno int
,ename varchar(max)
,sal money
)
GO
insert into Source_Tab values('vijay',2000)
GO
insert into Source_Tab values('kumar ',3000)
GO
insert into Source_Tab values('ravi ',4000)
GO
insert into Target_Tab
(
eno
,ename
,sal
)
select ROW_NUMBER() OVER (ORDER BY ename)
AS 'RowNumber',ename,sal from source_Tab
SELECT * FROM Target_Tab
GO
SELECT * FROM source_Tab
GO
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / kiran
ok well vijay.ur quetion not proper k.
see u can use s_key,column genaretor stage.
and u can define user define query in source level and
populated to target like dbl click on source and set read
method is user deine and write query=select
rownum,ename,sal from emp(s/r table name).k
Thanks&Regards
kiran
9393363309
Is This Answer Correct ? | 1 Yes | 5 No |
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
what is the use of surogate key in datastage
What are the areas of application?
How to transfer file from one system to another system in UNIX?which command to be use?
What is the difference between datastage and informatica?
how to convert rows into columns
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
Describe link sort?
What are the environmental settings for data stage,while working on parellel jobs?
How and where you used hash file?