How to remove duplicates in transformer stage? in parallel
mode
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
How many types of sorting methods are available in datastage?
Have you used Unstructured data?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Name the different sorting methods in datastage.
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the command line function to import and export the ds jobs?
table actions available in oracle connector?
What is the difference between the local container and shared container?
What is oci?
CHANGE CAPTURE
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 merge stage?
Why do we use link partitioner and link collector in datastage?
How can one find bugs in job sequence?