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
- 12555 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
Highlight the main features of datastage?
What are the main features of datastage?
What is difference between join, merge and lookup stage?
What is the difference between odbc and drs stage?
What is the difference between an operational datastage and a data warehouse?
How do you reject records in a transformer?
What are the primary usages of datastage tool?
What are the various kinds of the hash file?
Explain the importance of surrogate key in data warehousing?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is datastage engine?
Define APT_CONFIG in Datastage?
What is the purpose of pivot stage?
project Steps,hits, Project level HArd things,Solved methods?
What is the difference between server job and parallel jobs?
