Interested to Buy Any Domain ? << Click Here >> for more details...
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
- 4 Answers
- 8446 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / pavani
if we have n duplicates
source---->transformer-------->target.
in transformer we define 2 stage variables
if empno=stg_var2 then stg_var1+1 else 1------->stg_var1;
emp_no-------->stg_var2;
now the constraint for target is stg_var1=2
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How do you register plug-ins?
How do you reject records in a transformer?
What is the different type of jobs in datastage?
How rejected rows are managed in datastage?
What is aggtorec restructure operator?
How to perform incremental load in datastage?
How will you move hashed file from one location to another location?
Demonstrate experience in maintaining quality process standards?
Can you explain kafka connector?
how can we create rank using datastage?what is the meaning of rank?
What a datastage macro?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
EXPLAIN SCD
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
