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

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,


What is polling?

1 Answers  


After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,


What is domain and gateway node?

0 Answers  


Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,






Can we get 1st record through Informatica(without sequence number).

0 Answers  


How many repositories can be created in informatica?

1 Answers  


What is an expression transformation in informatica?

0 Answers  


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

0 Answers   CTS,


I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,


What are mapping parametres and variables in informatica?

6 Answers   TCS,


What is the use of target designer?

0 Answers  


Categories