Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 3609 Views
- Wipro, I also Faced
- E-Mail Answers
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 a dimensional model?
Define mapping and session?
Parameter and variable differences
What is target designer and target load order?
How can we use mapping variables in informatica? Where do we use them?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Briefly describe lookup transformation?
What is event and what are the tasks related to it?
what is index?how it can work in informatica
What is the difference between Active and Passive transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to elaborate powercenter integration service?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain pushdown optimization and types in informatica
Explain scd type 3 through mapping.
