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

How many Key we can define in remove duplicate stage?

1309

---

Highlight the main features of datastage?

1088

---

Demonstrate experience in maintaining quality process standards?

2453

---

AGGREGATOR default datatype

1386

---

Why do we use exception activity in Datastage?

1226

---

Where the datastage stored his repository?

1018

---

What are some different alternative commands associated with "dsjob"?

1079

---

To see hidden files in LINIX?

1449

---

Define meta stage?

1142

---

Enlist various types of routines in datastage.

1185

---

Can you implement SCD2 using join, transformer and funnel stage?

1495

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2836

---

What is difference between join, merge and lookup stage?

1035

---

Define data aggregation?

1045

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

863

---