Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
Please tell me how to solve this scenario in datastage ?
Here we have 3 columns in a table TEST
CODE,ENTRY DATE and BATCH
The table looks like
CODE ENTRYDATE BATCH
100 100716 1
100 100716 1
100 100716 1
200 122517 2
200 122517 2
302 555555 8
302 555555 8
302 555555 8
We need to create a seqno on grouping these 3 columns.
The result should be like this.
CODE ENTRYDATE BATCH SEQNO
100 100716 1 1
100 100716 1 2
100 100716 1 3
200 122517 2 1
200 122517 2 2
302 555555 8 1
302 555555 8 2
302 555555 8 3
- 1 Answers
- 3660 Views
- Alpharithm Technologies, I also Faced
- E-Mail Answers
Answer / raj
The only solution I can get readily is using stage variables in a transformer. In order to achieve this I need to define 3 stage variables to map them to input columns. Another 3 stage variables to store the previous value. Another 3 variables to compare the values. A total of 9 stage variables are needed.
To reduce the number of stage variables, lets us checksum stage
A checksum stage generates a unique value with the given columns as input.
We supply these three columns as input and generate unique values for each combination and then use that value for comparison in the transformer
Transformer:
Stage Variable:
Checksum -> Sv1
Sv2 -> Sv1
if Sv1=Sv2 then Sv3+1 else 1 -> Sv3
Sv3 -> SEQNO
We get the desired output
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the main difference between sorragate key n primary key in one word
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
Define Data Stage?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
Unix command to view the data in a dataset
What is the command line function to import and export the ds jobs?
What is a ds designer?
What are the different kinds of views available in a datastage director?
Which warehouse using in your datawarehouse
Teradata 
