can we override a native sql query within informatica? Where do we do it?
What is target designer and target load order?
What is union transformation?
Enlist the differences between database and data warehouse.
What is the difference between STOP and ABORT options in Workflow Monitor?
Which development components of informatica have the highest usage?
Can we create multiple integration service on single repository?
What are the different ways to implement parallel processing in informatica?
What is a repository manager?
Briefly explain the aggregator transformation?
Explain the difference between a data warehouse and a data mart?
What is the session task and command task?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to Create a folder using pmrep command?
What is the difference between router and filter?