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

what are the limitation of sorter transformation?

2 Answers   TCS,


How to delete duplicate row using informatica?

0 Answers  


how will you remove the duplicate records from flat file without using sorter?

7 Answers  


I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,


Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,






What is the command used to run a batch?

0 Answers  


What are the modules in Power Center

0 Answers  


Is it possible to use a client with different version than that of its Informatica server?

0 Answers  


How to delete duplicate record in Informatica?

7 Answers  


Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,


Define pmcmd command?

0 Answers  


Why update strategy and union transformations are active?

0 Answers  


Categories