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...

i hav a scenario like this i want load data from source to
target as follows frist it counts the num of deptno and
display with that with count and how many times it reapts
along with all the records in source

Answer Posted / santha

for this scenario You can use the ANALYTIC function.It give
all the total count and individual count...

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly explain the aggregator transformation?

941


Which transformation should we use to normalise the COBOL and relational sources?

1141


What is a predefined event?

1032


Explain your project of banking domian.

1605


Describe data concatenation?

1005


what is the complex transformation you used in informatica

2524


What is Session and Batches?

1040


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2099


How will the document be delivered to me?

1018


what is index?how it can work in informatica

1980


What is a snowflake schema?

924


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4035


Differentiate between Load Manager and DTM?

2093


in reporting we add some new objects,how we get the count of the newly added objects to the report

2130


complex mapping ur project u r invlve can u explain and give real time example give me ?

2235