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.
Answer Posted / 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 View All Answers
what is degenerated dimension?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How does a sorter cache works?
Target increases every day even though no new record was inserted
What is the meaning of decode in informatica?
what is the complex transformation you used in informatica
How to update a particular record in target with out running whole workflow?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Performance tuning( what you did in performance tuning)
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
can we override a native sql query within informatica? Where do we do it? How do we do it?