Answer Posted / 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

Describe the architecture of datastage?

1010

---

Define repository tables in datastage?

1162

---

Triggers,VIEW,Procedures

1225

---

What is datastage?

1088

---

what is use of SDR function?

5176

---

what is flow of project?

2002

---

Difference between sequential file and data set?

1206

---

What is a ds designer?

1070

---

how can we create rank using datastage?what is the meaning of rank?

8795

---

Explain ibm infosphere information server and highlight its main features?

1091

---

What is a quality stage in datastage tool?

1079

---

What steps should be taken to improve Datastage jobs?

1075

---

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

1296

---

How many types of sorting methods are available in datastage?

1075

---

How a source file is populated?

1068

---