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

What is datastage engine?

1225

---

What is ibm datastage flow designer?

1204

---

What is active and passive stage?

1469

---

What are the partitioning techniques available in link partitioner?

2330

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1462

---

How the ipc stage work?

1170

---

how to implement scd2 in datastage 7.5 with lookup stage

5666

---

whom do you report?

1986

---

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

1044

---

How do you import and export data into datastage?

1298

---

What is process model?

2026

---

What is "fatal error/rdbms code 3996" error?

1344

---

Explain Quality stage?

1211

---

What is the roundrobin collector?

1151

---

What is the command line function to import and export the ds jobs?

1193

---