What are different types of transformations available in informatica?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
What is galaxy shema
which one is better performance wise joiner or look up
Explain Dataware house architecture .how data flow from intial to end?
What is Session and Batches?
How do you implement configuration management in Informatica?
What are limitations of joiner transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How can we get two output ports in un-connect transformation?
what is fact table?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?