Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove duplicates in transformer stage? in parallel
mode
- 6 Answers
- 17472 Views
- Syntel, TCS, I also Faced
- E-Mail Answers
Answer Posted / prasad
Take 2 Stage variables in transformer stage
sV1 =Column_Name
sV2 =if Column_Name=sV1 Then 0 Else 1
put it constraint sV2=1 (only will get unique records)
if u want duplicates sV2=0
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
sed,awk,head
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the different type of jobs in datastage?
What is usage analysis in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
how to delete one row in target dataset
What is a datastage job?
What are the some differences between 7.x and 8.x version of datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How do you schedule or monitoring the job?
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)
What is difference between server jobs & parallel jobs?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are stage variables, derivations and constants?
Whats difference betweeen operational data stage (ods) and data warehouse?
