Interested to Buy Any Domain ? << Click Here >> for more details...
how to remove duplicates in transformer stage by using
stage variables?one example?
- 6 Answers
- 33915 Views
- Syntel, TCS, I also Faced
- E-Mail Answers
Answer Posted / prasad
take two stage variables
sV1: Input_column
sV2: if Input_column = sV1 then 0 else 1
and put 'sV1=1' as constraint
Plz correct me, If am wrong.....
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
How can we improve performance of data stage jobs?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is size of a transaction and an array means in a datastage?
what is the difference between == and eq in UNIX shell scripting?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How to Remove Duplicate using SQL?
how to delete one row in target dataset
Define Merge?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the types of hashed files in data stage
What is apt_config in datastage?
Define APT_CONFIG in Datastage?
client know skid info?
Differentiate between data file and descriptor file?
