Answer Posted / venkata ramana

Input Seq File:-

NAME,LOC
Ram,hyd
Ram,ban
Raj,chn
Raj,Pun
Sam,del

seq---Trans---Rem Dups----> Dataset


TRANSFORMER:
------------
STEP1:

Create 3 stage variables like s1,s2,s3

DSLink3.NAME --->s1

If s1<>s3 then DSLink3.LOC else s2:DSLink3.LOC --->s2

s1--->s3

STEP2:

Derivations Column bane

s2------------> LOC


Remove duplicate stage:
-----------------------

Key == NAME

Duplicate To Retain = Last


Output Dataset result:-

NAME LOC
Ram Hyd ban
Raj chn pun
sam del

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2279

---

What are the different types of lookups in datastage?

1061

---

what is flow of project?

2007

---

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

1415

---

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

1123

---

Is possible to create skid in dim,fact tables?

2647

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2391

---

What are the functionalities of link partitioner?

1026

---

What are some prerequisites for datastage?

1107

---

How and where you used hash file?

1180

---

What are the different options associated with dsjob command?

1449

---

Define meta stage?

1209

---

How many types of stage?

1183

---

What is the difference between server job and parallel jobs?

1164

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2500

---