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
- 20094 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / msbharathi
- > Unique
Sq File - > Aggregate - > Transformer |
- > Duplicate
1. Read data in seq file stage.
2. In Aggregate stage group by EID and count the number of rows in Count column
3. In transformer stage create loop condition as @ITERATION<= DSLink6.Count and derivation as EID = EMPNO.
4. In unique output tab use constraint count<=1 and in duplicate output tab use constraint count>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the process of killing a job in datastage?
Define Job control?
in oracle target stage when we use load option and when we use upsert option?
How do you import and export the datastage jobs?
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
what are the errors,warnings in datastage
Which warehouse using in your datawarehouse
What is the command line function to import and export the ds jobs?
How can we improve performance of data stage jobs?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How can one find bugs in job sequence?
How many types of sorting methods are available in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
How one source columns or rows to be loaded in to two different tables?
What are orabulk and bcp stages?
