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
- 12271 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
What are some prerequisites for 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
On which interface you will be working as a developer?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is usage analysis in datastage?
What is the difference between an operational datastage and a data warehouse?
How do you register plug-ins?
how to implement scd2 in datastage 7.5 with lookup stage
Lookup constraints
What is a quality stage in datastage tool?
How can you write parallel routines in datastage PX?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
CHANGE CAPTURE
Can you explain kafka connector?
what is the difference between == and eq in UNIX shell scripting?
