Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 9317 Views
- IBM, I also Faced
- E-Mail Answers
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 ds administrator used for?
What are the steps needed to create a simple basic datastage job?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Define APT_CONFIG in Datastage?
What is the purpose of pivot stage and types of containers in datastage
On which Dimension Table you implemented SCD Type in your Project
Explain how a source file is populated?
What is the roundrobin collector?
Is it possible to query a hash file?
How rejected rows are managed in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
What is the difference between informatica and datastage?
Define Merge?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How many areas for files does datastage have?
