Interested to Buy Any Domain ? << Click Here >> for more details...
souce file having the columns like
name company
krish IBM
pooja TCS
nandini WIPRO
krish IBM
pooja TCS
if first row will be repeat i want the result like this
name company count
krish IBM 1
pooja TCS 1
nandini WIPRO 1
krish IBM 2
pooja TCS 2
- 9 Answers
- 11942 Views
- I also Faced
- E-Mail Answers
Answer Posted / pushparaj
Just modified the last post with minor changes
First sort the both name and compamy and then,
using stage variable in transformer:
sv1= name:company
sv3=if sv1=sv2 then sv3+1 else sv3(initial value of sv3=1)
sv2=sv1(initial value of sv2 =XXXXXXX)
OP
name company count=sv3
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
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
How do you import and export data into datastage?
What are the benefits of datastage?
Where do the datastage jobs get stored?
How to implement complex jobs in data stage?
Differentiate between hash file and sequential file?
What are routines in datastage?
EXPLAIN SCD
Can you filter data in hashed file?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Define data aggregation?
What is the difference between orabulk and bcp stages?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How to manage date conversion in Datastage?
Where the datastage stored his repository?
