1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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.

Question Posted / guest


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

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

What are differences between Informatica 7.1 and 6.1

3 Answers  

What aer the out put files that the informatica server creates during the session running?

4 Answers  

When do you use sql override in a lookup transformation?

0 Answers  




Differentiate between mapping parameter and mapping variable?

1 Answers  

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

What are the tasks that Loadmanger process will do?

1 Answers  

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

What are the scheduling options to run a sesion?

2 Answers  

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

For more Informatica Interview Questions Click Here
Categories