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

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2501

---

What are system variables and sequencers in datastage

1115

---

On which Dimension Table you implemented SCD Type in your Project

2024

---

What are datastage sequences?

1116

---

Define project in datastage?

1090

---

Explain connectivity between datastage with datasources?

970

---

Differentiate between hash file and sequential file?

1066

---

How to implement complex jobs in data stage?

1108

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1084

---

Where do the datastage jobs get stored?

1210

---

Can you filter data in hashed file?

3772

---

What are stage variables, derivations and constants?

1218

---

What are the features of datastage flow designer?

1035

---

What is a datastage job?

1011

---

Difference between in process and inter process?

1223

---