After SQ take exp trans exp : V_COUNT=V_COUNT+1 O_COUNT=V

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 / kamleshmishra291

1 Answers
3560 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

Please Help Members By Posting Answers For Below Questions

Does an informatica transformation support only aggregate expressions?

1018

What is deployment group?

1180

What are the types of caches in lookup?

1028

in reporting we add some new objects,how we get the count of the newly added objects to the report

2171

How can informatica be used for an organization?

1189

What are the types of presistent cache in look up tr.

2042

Explain the etl program with few examples.

1026

Enterprise data warehouse your projects phase by phase explain?

1903

What do think which one is the better joiner or look up?

1184

Can we create two repositories on same database instance in oracle?

1072

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1883

Is there any way to read the ms excel datas directly into informatica?

1010

What are the popular informatica products?

997

what is unit testing?tell me proceedure

2200

What are the reusable transformations?

1133