what is service oriented architecture in Informatica 8 version
HOW TO YOU LOAD TIME DIMENSION
What are parallel querys and query hints?
where to store informatica rejected data? How to extract the informatica rejected data?
What are session parameters ? How do you set them?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
how will you remove the duplicate records from flat file without using sorter?
how to declare array in plsql?
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?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
how can import the data from the flat files?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")