What is the purpose of using UNIX commands in Informatica. Which UNIX commands are
generally used with Informatica.
When should you create the dynamic data store? Do you need a DDS at all?
Which SDLC suits best for the data warehousing project.
Can a source qualifier be used to perform a outer join when joining 2 database?
Difference between static cache and dynamic cache?
How can you complete unrcoverable sessions?
How do you handle two sessions in Informatica
How the Informatica server increases the session performance through partitioning the source?
How to run a workflow without using GUI i.e, Worlflow Manager, Workflow Monitor and
In what all transformations the mapplets cant be used in Informatica??
What are mapping parameters and varibles in which situation we can use it
What are the different types of Commit intervals?
What are the tasks that Loadmanger process will do?
What does the first column of bad file (rejected rows) indicate? Explain
What is Code Page Compatibility?
What is key factor in BRD?
What is Strategy Transformation
What is the difference between Rank and Dense Rank?
What is the Rankindex in Ranktransformation?
When the informatica server marks that a batch is failed?
Which tool you use to create and manage sessions and batches and to monitor and stop the
Can any one explain real time complain mappings or complex transformations in
Informatica.Specially in Sales Domain.
Discuss the advantages & Disadvantages of star & snowflake schema?
How can you create or import flat file definition in to the warehouse designer?
How do you identify existing rows of data in the target table using lookup transformation?
How the informatica server sorts the string values in Ranktransformation?
How to use incremental aggregation in real time?
In which circumstances that Informatica server creates Reject files?
What are mapplets?
What are the different types of locks?
What are the tasks that source qualifier performs?
What exactly is a shortcut and how do you use it?
What is Code Page used for?
What is Load Manager?