Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
1323Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
1312Post New Informatica Questions
What are the different components of powercenter?
What can we do to improve the performance of informatica aggregator transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain the shared cache and re-cache?
how to load dimension table and fact table. plz tell me the steps.
What is an active transformation?
How to do unit testing in informatica? How to load data in informatica ?
Briefly define a session task?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What does update strategy mean, and what are the different option of it?
Explain Dataware house architecture .how data flow from intial to end?
Is it possible to create multiple domains on a single Informatica server?
What are Dimensional table?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Informatica settings are available in which file?