Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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


Answer Posted / abc

we can use aggregator stage.. nad group on the basis of name and company...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is apt_config in datastage?

1142


What are the different kinds of views available in a datastage director?

1033


How you can fix the truncated data error in datastage?

1797


which r the connectors used in san?

2188


options available in sequence job to run,validate?

1325


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1088


what is flow of project?

2002


Define Data Stage?

1098


How one source columns or rows to be loaded in to two different tables?

1130


What are sequencers?

1124


I have a few records just I want to store data in to targets cycling way how?

2375


What is the purpose of pivot stage?

1172


What is job control?

1120


What is the difference between orabulk and bcp stages?

1028


What all are the different way to run a job?

1096