i have data like
sam
ram
sam
raj
ram
I want two targets
trgt1
ram
sam
trgt2
raj
how can i do this in datastage?
Answer Posted / subhash
1) If SRC is either Oracle or Seq File
SRC--->AGG---->fILTER---->TGT1
...................|
...................|
..................TGT2
the main data is:
sam
ram
sam
raj
ram
from aggregator stage, the output is:
sam,2
ram,2
raj,1
Then specify the count<>1 in the Filter for TGT1 then you get:
ram
sam
in another link for TGT2, give count=1. THEN YOU GET:
raj
2) If SRC is DataBase,
Orcl Conector----->Filter---->TGT1
.......................|
.......................|
......................TGT2
SELECT NAME, COUNT(NAME)
FROM EABLE_NAME
GROUP BY (NAME)
from the Above Query, the output is:
sam,2
ram,2
raj,1
Then specify the count<>1 in the Filter for TGT1 then you get:
ram
sam
in another link for TGT2, give count=1. THEN YOU GET:
raj
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the sortmerge collector?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How to perform incremental load in datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How we can covert server job to a parallel job?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the repository tables in datastage?
What is the precedence of stage variables,derivations, and constraints?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Difference between in process and inter process?
Highlight the main features of datastage?
Differentiate between Join, Merge and Lookup stage?
What are transforms and what is the differenece between routines and transforms?
What are the different type of jobs in datastage?
How the ipc stage work?