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 have a text file name x
With a text message. Word informatica
Is repeated for n number of times.
How to count the number of occurrence
Of word informatica

Of word informatic in this file x.



I have a text file name x With a text message. Word informatica Is repeated for n number of times. ..

Answer / kamleshmishra291

After SQ take exp trans
exp :
V_COUNT=V_COUNT+1
O_COUNT=V_COUNT
Aggr trans :
COUNT(O_COUNT)

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  


Have you worked with/created Parameter file

0 Answers  


what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,


i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,


What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,


In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,


hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  


Useful UNIX commands regular/frequently used

1 Answers   Deloitte,


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

0 Answers  


What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,


My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,


Categories