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

Whats difference betweeen operational data stage (ods) and data warehouse?

1102

---

Which commands are used to import and export the datastage jobs?

1405

---

What is the difference between in process and inter process?

1128

---

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

3984

---

On which Dimension Table you implemented SCD Type in your Project

2014

---

What are sequencers?

1094

---

Differentiate between validated and Compiled in the Datastage?

1256

---

What are orabulk and bcp stages?

1110

---

Name the third party tools that can be used in datastage?

1064

---

Does datastage support slowly changing dimensions ?

1096

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2232

---

What are the job parameters?

1208

---

What is the difference between hashfile and sequential file?

1243

---

Where do you see different stages in the designer?

1076

---

What is ibm datastage?

955

---