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

Why do we use exception activity in Datastage?

1374


Is it possible to query a hash file?

2062


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1277


root tree will find which is server job and which is parallel job?

2043


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2934


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2283


How to read multiple files using a single datastage job if files have the same metadata?

1306


whom do you report?

1986


What are transforms and what is the differenece between routines and transforms?

1110


What is the process of killing a job in datastage?

1072


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

1065


In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1100


How you can fix the truncated data error in datastage?

1889


what is the difference between == and eq in UNIX shell scripting?

1561


How many types of hash files are there?

1238