View Full Version : Informatica
- what is the flow
- How to load time dimension
- Why to use stored procedure in ETL Application
- what is difference between COM & DCOM
- How do you create single lookup transformation using multiple tables
- How to improve the performance of Aggregate transformation
- How to call stored Procedure from Workflow monitor in Informatica 7.1 version
- How to view and Generate Metadata Reports
- what is the gap analysis
- How to recover sessions in concurrent batches
- Where is the cache stored in informatica
- what is Partitioning ? where we can use Partition
- what are the different types of transformation available in informatica
- what is polling
- what is difference between dimension table and fact table
- what happens if you try to create a shortcut to a non- shared folder
- what is worklet and what use of worklet and in which situation we can use it
- How to import oracle sequence into Informatica
- What is IQD file
- what is the exact meaning of domain
- How do you handle decimal places while importing a flatfile into informatica
- What is data merging, data cleansing, sampling
- what are the enhancements made to Informatica 7.1.1 version compared to 6.2.2 version
- What is the difference between Power Centre and Power Mart
- why dimension tables are demoralized in nature
- What is the use of incremental aggregation
- What is the procedure to load the fact table. Give in detail
- what is a junk dimension
- What is the difference between Normal load and Bulk load
- what is a time dimension
- What are the reusable transformations
- What is aggregate cache in aggregator transformation
- Discuss the advantages & Disadvantages of star & snowflake schema
- What are the basic needs to join two sources in a source qualifier
- which circumstances that informatica server creates Reject files
- When the informatica server marks that a batch is failed
- What is a command that used to run a batch
- Define informatica repository
- What is Code Page Compatibility
- What are Target Options on the Servers
- What are the types of metadata that stores in repository
- What is tracing level and what are the types of tracing level
- What are Dimensions and various types of Dimensions
- Why we use lookup transformations
- Explain about perform recovery
- How to recover the standalone session
- What is difference between maplet and reusable transformation
- What are the data movement modes in informatcia
- What are the out put files that the informatica server creates during the session
- What is mystery dimension
- What are the different types of Type2 dimension mapping
- Explain about the concept of mapping parameters and variables
- what are cost based and rule based approaches and what is the difference
- What is the difference between stop and abort
- What is Micro Strategy? Why is it used for
- what is the difference between Informatica 7.1 and Abinitio
- Explain the flow of data in informatica
- What is status code
- What is the difference between OLTP and ODS
- What are the two modes of data movement in informatics sever
- What is confirmed dimension and fact
- What is facttable granularity
- when we run the session in the nexttime
- What are limitations of joiner transformation
- How can we eliminate duplicate rows from flat file
- What is the functionality of update strategy
- What are different tasks that can be created in workflow manager
- Name 4 output files that informatica server creates during session running
- What are the different threads in DTM process
- What are the different types of schemas
- How to enter same record twice in the target table
- What is the Difference between DSS & OLTP
- What is source qualifier
- Explain grouped cross tab
- What are mapping parameters and variables in informatica
- Explain one complicated mapping
- What is exact use of 'Online' and 'Offline' server connect Options
- What is the logic will you implement to load the data in to one fact from 'n' number
- What are the real times problems generally come up while doing or running mapping or
- How can we join the tables if they don't have primary and foreign key relationship
- When do we use dynamic cache and static cache in connected and unconnected lookup
- What are precession, possession success and possession failure commands
- How to identify bottlenecks in sources, targets, mappings, workflow, system
- What is the Hierarchy of DWH
- How many repositories can we create in Informatica
- What is surrogate key
- What is difference between Mapplet and reusable transformation
- What is aggregate awareness
- Explain reference cursor
- What is a transformation
- What are the designer tools for creating transformations
- What are the active and passive transformations?
- What are the connected or unconnected transformations
- How many ways you create ports
- What are the methods for creating reusable transformations
- What are the unsupported repository objects for a mapplet
- What are the mapping parameters and mapping variables
- Why use the lookup transformation
- What are the types of lookup
- What are the Differences between connected and unconnected lookup
- what is meant by lookup caches
- what is the look up transformation
- What are the joiner caches
- What are the join types in joiner transformation
- what are the settings that u use to configure the joiner transformation
- What are the differences between joiner transformation and source qualifier transform
- How can you create or import flat file definition in to the warehouse designer
- Which transformation should u need while using the COBOL sources as source definition
- How many ways you can update a relational source definition
- What are the rank caches
- What is the Rank index in Rank transformation
- What is the Router transformation
- What are the types of groups in Router transformation
- Why we use stored procedure transformation
- What are types of data that passes between informatica server and stored procedure
- How the informatica server sorts the string values in Rank transformation
- What are the types of lookup caches
- What are the Differences between static cache and dynamic cache
- Which transformation should we use to normalize the COBOL and relational sources
- In which conditions we can not use joiner transformation
- Where should you place the flat file to import the flat file definition to the design
- To provide support for Mainframes source data, which files r used as a COBOL files
- What is the status code
- What is source qualifier transformation
- What are the tasks that source qualifier performs
- What is the target load order
- What is the default join that source qualifier provides
- What is update strategy transformation
- Describe two levels in which update strategy transformation sets
- What is Data driven
- What is the default source option for update strategy transformation
- What are the options in the target session of update strategy transsformatioin
- What are the types of mapping wizards that r to be provided in Informatica
- What are the types of mapping in Getting Started Wizard
- What are the mappings that we use for slowly changing dimension table
- Define mapping and sessions
- What are two types of processes that informatica runs the session
- What is metadata reporter
- What are the new features of the server manager in the informatica 5.0
- What is DTM process
- What are the tasks that Load manger process will do
- Can you copy the session to a different folder or repository
- What is batch and describe about types of batches
- Why you use repository connectivity
- Can you start batches with in a batch
- Can you start a session inside a batch individually
- How many number of sessions that u can create in a batch
- In which circumstances that informatica server creates Reject files
- Why we use partitioning the session in informatica
- What are the different options used to configure the sequential batches
- How can you stop a batch
- What are the session parameters
- What is parameter file
- How can you access the remote source into your session
- What is Performance tuning in Informatica
- What is power center repository
- what are the transformations that restricts the partitioning of sessions
- What is difference between partitioning of relational target and partitioning
- What are the scheduling options to run a session
- What is incremental aggregation
- What are the new features in Informatica 5.0
- How can you work with remote database in informatica
- Explain about Recovering sessions
- What is difference between stored procedure and external procedure transformation
- What is operational data source (ODS)
- What are the Advantages of de normalized data
- What is Meta data and system catalog
- What is the capacity of power cube
- What is hash partition
- Which kind of index is preferred in DWH
- What is staging area
- What is query panel
- What is data merging, data cleansing and sampling
- What is up date strategy and what are the options for update strategy
- What is difference between a connected look up and unconnected look up
- What is a look up function? What is default transformation for the look up function
- What is power play plug in
- What is COGNOS script editor
- What is the Difference between Power Play transformer and power play reports
- How can you recover the session in sequential batches
- How can you complete unrecoverable sessions
- What are the circumstances that infromatica server results an unrecoverable session
- How can you define a transformation
- What are different types of transformations in Informatica
- How the informatica server increases the session performance through partitioning
- Which tool you use to create and manage sessions and batches and to monitor and stop
- How can you recognise whether or not the newly added rows in the source r gets insert
- Why do we use DSS database for OLAP tools
- What is active and passive transformation
- How is Data Models Used in Practice
- What is an MDDB? What is the difference between MDDBs and RDBMSs
- What is the difference between view and materialized view
- What is the approximate size of data warehouse
- Why do you use shortcuts in informatica
- How do you move the code from development to production
- What are the values that are passed between informatics server and stored procedure
- What is the difference between onsite & client site
- What are the transformations that are not involved in mapplet
- What are differences between Informatica 7.1 and 6.1
- How to get the latest data in scd
- What is the function of 'F10' informatica
- What are the reusable tasks in informatica
- How do you perform incremental load
- What is fact tables
- What happens when a batch fails
- What is parallel querying and what are hints
- How do you take care of security using a repository manager
- Can you use one mapping to populate two tables in different schemas
- Which one is loaded first Fact Table or Dimensions Table into the warehouse
- How does you move the code from development to production
- What?s the difference between $, $$, $$$
- What is update override
- Difference between sql override and update override
- How do you connect to remote server
- What Is The Name Of That Port In Dynamic Cache Which Is Used For Insert , Update
- How the server recognizes, if the session fails after loading the 100 records
- What Version controlling in informatics
- Is Flat File Contains the Dynamic Cache?
- What is data quality
- How can a data quality solution be implemented into my informatica transformations
- What is the filename which you need to configure in UNIX while installing infromatica
- What is the size of the Fact Table and Dimension Table
- What is the size of the table and warehouse
- What are the transformations that are used in data cleansing
- Why is meant by direct and indirect loading options in sessions
- where we can start or use pmcmd
- What is the logic will you implement to load data into a fact table from n dimension
- What is Factless fact tabl
- What is incremental aggregation and how it is done
- Why we need to use unconnected transformation
- What is a diff between joiner and lookup transformation
- What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
- How can we eliminate duplicate values from lookup without overriding SQL
- What is difference between stop and abort
- How you know when to use a static cache and dynamic cache in lookup transformation
- Explain about HLD and LLD
- why cant we put a sequence generator or upd strategy before joiner transformation
- what is shared Cache. when we will use shared Cache
- whether Sequence generater T/r uses Caches? then what type of Cache it is
- What happens if you increase commit intervals and also decrease commit
- How do u use sequence created in oracle in informatica
- Without using any transformations how u can load the data into target
- How could we generate the sequence of key values without using sequence generator
- What is the method loading 5 flat files of having same structure to a single target
- Explain the scenario for bulk loading and the normal loading in Informatica Work
- How to use the Oracle Analytic functions in Informatica
- What are surrogate keys usage in Oracle and Informatica
- How many Fact Tables and Dimensions Table you have used in the Project
- How data cleansing takes place
- How will you find weather dimension table is big in size of a fact table