Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove duplicates in transformer stage? in parallel
mode
- 6 Answers
- 17119 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
Name the third party tools that can be used in datastage?
which r the connectors used in san?
Could anyone give brief explanation bout datastage admin
What is aggtorec restructure operator?
In Datastage, how you can fix the truncated data error?
how to delete one row in target dataset
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Which warehouse using in your datawarehouse
What is ibm datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are the types of containers in datastage?
in oracle target stage when we use load option and when we use upsert option?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is job control?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
