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 if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
What are the advantages of informatica?
How will the document be delivered to me?
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
How do you change a non-reusable transformation to reusable transformation?
From where we can start or use pmcmd?
what is lookup chache?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
In a concurrent batch if a session fails, can you start again from that session
What is resilience time?
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,