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



i hav a scenario like this i want load data from source to target as follows frist it counts the ..

Answer / 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

More Informatica Interview Questions

what are the types of Data warehousing ?

1 Answers  


Explain what is informatica metadata and where is it stored?

0 Answers  


How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,


How do you use reject loader.

0 Answers  


I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  


what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,


How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,


Write the different tools in the workflow manager?

0 Answers  


How can we remove the duplicates from flat file source?

0 Answers  


what is size of u r database?

0 Answers  


What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,


Categories