Answer / pavan

Hi This is pavan u use surrogate key generator.

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

Answer / surya

you can generate surrogate key in the transformer itself.
right click on the stage variables. tre you can find surrrogate key.

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

Answer / d

d

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.

Answer / sindhu

row number column in sequential file

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

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

how many stages are there in Datastage... Please clarify mee??

3 Answers  

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

What is the difference between operational data stage (ods) and data warehouse?

0 Answers  

what is meta data? Explain? Where it is used?

9 Answers  

How many types of views are there in a datastage director?

0 Answers  

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

what is time dimension? and how to populate time demension

2 Answers   TCS,