how to remove duplicates in transformer stage by using
stage variables?one example?
- 6 Answers
- 32219 Views
- Syntel, TCS, I also Faced
- E-Mail Answers
Answer Posted / ds
In Stage variable:
stage_variable3 <map> stage_variable1
if column=stage_variable1 than 0 else 1 <map>
stage_variable2
column <map> stage_variable3
Put stage_variable2 as constrain to target stage.
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Which commands are used to import and export the datastage jobs?
Define project in datastage?
project Steps,hits, Project level HArd things,Solved methods?
sed,awk,head
What are the main features of datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are transforms and what is the differenece between routines and transforms?
Difference between sequential file and data set?
On which interface you will be working as a developer?
What is quality stage?
What is ds designer?
What are the different layers in the information server architecture?
in oracle target stage when we use load option and when we use upsert option?
