Interested to Buy Any Domain ? << Click Here >> for more details...
i want send my all duplicate record one tar and all uniq
records one target how we will perfome explain
example:
input data
eid
251
251
456
456
951
985
out put/target1
251
251
456
456
out put/target2
951
985
how we will bring
- 13 Answers
- 20627 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / sreenu
Using aggregation and filter stage,
In aggregation stage we calculate the count of incoming
records and in filter we use count<>1 for output1, count=1 for
output2...
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Why fact table is in normal form?
Explain entity, attribute and relationship in datastage?
what is the use of materialized view?
Explain the situation where you have applied SCD in your project?
Notification Activity
Define repository tables in datastage?
How a source file is populated?
how many rows sorted in sort stage by default in server jobs
What are the different layers in the information server architecture?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
AGGREGATOR default datatype
What is the difference between the local container and shared container?
What is the difference between odbc and drs stage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Define oconv () and iconv () functions in datastage?
