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
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain the different kinds of facts.
What is workflow? What are the components of the workflow manager?
What are the different lookup cache(s)?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Clarify the utilization of aggregator cache record?
What is the need for an etl tool?
How many number of sessions can one group in batches?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is confirmed fact in dataware housing?
how to load rows into fact table in data warehouse
What is persistent lookup cache?
What are the different types of olap? Give an example?
what is mean by complex business rule ?
What is a code page?