how to remove duplicates in transformer stage by using
stage variables?one example?
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
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the different types of lookups in datastage?
What is usage analysis in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How to read the length of word in unix?
What are the various kinds of containers available in datastage?
What is a datastage job?
What is aggtorec restructure operator?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Highlight the main features of datastage?
Can you implement SCD2 using join, transformer and funnel stage?
how can we create rank using datastage?what is the meaning of rank?