Why update strategy and union transformations are active? Explain with examples.
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
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?
What does role playing dimension mean?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
What is a mapplet/worklet in informatica?
What are parallel querys and query hints?
What is DR strategy for Informatica project?
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.