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
- 11955 Views
- I also Faced
- E-Mail Answers
Answer Posted / shasank, pr3systems
use transforemr stage and give three stage variable with intial value as 0,
then give (if company=ibm then count=count+1 else stgvar1)
like give three conditions for remaing two companies in two stage variables)
and in column derivation give if company=ibm then stgvar1 else
if company=wipro then stgvar2 else if company=tcs then stgvar3 else 0(company not in list)
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is difference between join, merge and lookup stage?
Where do the datastage jobs get stored?
What are the main features of datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
project Steps,hits, Project level HArd things,Solved methods?
What are the stages in datastage?
Define project in datastage?
What is difference between server jobs & parallel jobs?
how can we create rank using datastage?what is the meaning of rank?
What are iconv and oconv?
Nls stands for what in datastage?
Notification Activity
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
