Hi
Can any one help regarding below
INPUT
NAME LOC
Ram hyd
Ram ban
Raj chn
Raj Pun
Sam del
OUPUT
NAME LOC
Ram Hyd ban
Raj chn pun
sam del
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
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the difference between the local container and shared container?
Which commands are used to import and export the datastage jobs?
What is the purpose of interprocessor stage in server jobs?
what is the use of skid in reporting?
Why do you need stage variables?
What are the types of jobs we have in datastage?
Give an idea of system variables.
Lookup constraints
what is the use of surogate key in datastage
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Why do we use link partitioner and link collector in datastage?
What is the roundrobin collector?
Name the command line functions to import and export the DS jobs?
What is orabulk stage?