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
- 3661 Views
- Alpharithm Technologies, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many types of sorting methods are available in datastage?
Which commands are used to import and export the datastage jobs?
What all are the different way to run a job?
What is the purpose of pivot stage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are the types of containers in datastage?
How to clean the datastage repository?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Define Routines and their types?
What are the various kinds of containers available in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is the different type of jobs in datastage?
Where do you see different stages in the designer?
What is the difference between informatica and datastage?
