can we override a native sql query within informatica? Where do we do it? How do we do it?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different versions of informatica?
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
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
What are the components of workflow manager?
how can we use sorter transformation in joins?
What is persistent lookup cache?
How can you differentiate between powercenter and power map?
What is option by which we can run all the sessions in a batch simultaneously?
major difference between normal loading and bulk loading?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
What is the use of incremental aggregation?