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 to duplicates from expression transformation without using sorter before that
Why we use partitioning the session in informatica?
What are the popular informatica products?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain how many types of dimensions are available in informatica?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Differences between connected and unconnected lookup?