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
- 10103 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 the flow of loading data into fact & dimensional tables?
Differentiate between odbc and drs stage?
What is apt_config in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the difference between operational data stage (ods) and data warehouse?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How do u convert the columns to rows in datastage?
How do you register plug-ins?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the different layers in the information server architecture?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are the components of datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are the types of views in datastage director?
