can we use union transformation in joiner transformation?how?
Name the different lookup cache(s)?
What is metadata reporter?
Difference between task flow and linear task flow
what are testing in a mapping level please give brif eplanation
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
What is the need of building a data warehouse?
performance wise which one is better in joiner and lookup transformation
what is the flat file partition and where have to specify it
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?
Why we use lookup transformations?
What is the difference between Normal load and Bulk load?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?