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.
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 |
what is Partitioning ? where we can use Partition?
What are mapplets? How is it different from a Reusable Transformation?
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
How you know when to use a static cache and dynamic cache in lookup transformation?
When the informatica server marks that a batch is failed?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is Data Caches size?
Which is costliest transformation? costly means occupying more memory?
How to generate a single mapping for both the historical and incremental load.
What are the reusable transforamtions?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.