| What is a Data Warehouse? |
| What is a Data mart? |
| What is OLAP? |
| What is OLTP? |
| What are Dimensions? |
| What are Confirmed Dimensions? |
| What are Fact Tables? |
| What are the types of Facts? |
| What are the types of Fact Tables? |
| What is Grain of Fact? |
| What is Factless Fact table? |
| What are Measures? |
| What is a Star schema design? |
| What is Snow Flake schema Design? |
| What is Operational Data Store [ODS] ? |
| What is DE normalization? |
| What is Surrogate Key? |
| What is Metadata? |
| What is a Repository? |
| What is Data Acquisition Process? |
| What are the GUI based ETL tools? |
| What are programmatic based ETL tools? |
| What is a Transformation? |
| What are the types of metadata stored in Repository? |
| What are the types of locks in Repository? |
| What are Repository objects which we can export? |
| What is a Work Flow? |
| What are actions which can be performed by pmcmd command? |
| What is commit interval? |
| What is the use of Stored Procedure Transformation? |
| What is the use of partitioning the sessions? |
| What is the uses of Lookup Transformation? |
| What is a Parameter File? |
| What is Metadata Reporter? |
| What is meant by Lookup Cache? |
| What is a Load Manager? |
| What are the tasks performed by Sequence Generator Transformation? |
| What is the end value of the Sequence Generator? |
| What are variables supplied by the Transaction Control Transformation? |
| What are constants of Update Strategy Transformation? |
| What are the benefits of Star Schema Design? |
| What is Data Scrubbing? |
| What are Bad Rows (Rejected Rows)? |
| What are types of Dimensional Modeling? |
| What is Forward Engineering? |
| What is common use of creating a Factless Fact Table? |
| What are the different sources of Source systems of Data Warehouse? |
| What are the Session Partitions types? |
| What is stop the Batch and types of Batches? |
| What is a tracing level and types of Tracing level? |
| What is the default join that source qualifier provides? |
| What are Update Strategy?s target table options? |
| What does a Mapping document contains? |
| What does the Top Down Approach says? |
| What does the Bottom Up Approach or Ralph Kimball Approach says? |
| What is a Dimension Modeling? |
| What are the types of OLAPs ? |
| What is the extension of Repository backup? |
| What is SQL Override? |
| What is Rank Index? |
| What is Sort Key? |
| What is default group in Router Transformation? |
| What is unconnected Transformation? |
| What is Connected Transformation? |
| What are the caches contained by the Look up Transformation? |
| What are the Direct and Indirect methods in the Flat file extraction? |
| What is the Maplet? |
| What is the basic difference between reusable transformation and mapplet? |
| What is Target Load Plan? |
| What is Constraint Based Load ordering? |
| What is File Watch Event? |
| What is worklet? |
| What are the types of data that passes between Informatica server and stored procedure? |
| What are the groups available in Router Transformation? |
| What are join types in Joiner Transformation? |
| What are the designer tools available for creation of Transformations? |
| What are the basic needs to join two sources in Source Qualifier? |
| What is a Status code? |
| What is Data Driven? |
| What are the tasks to be done to partition a session? |
| What are Target Types on the Server? |
| What is the aggregate transformations? |
| What is Code Page used for? |
| What is a source qualifier? |
| What are the settings that you use to configure the joiner transformation? |
| What are the session parameters? |
| What are the methods for creating reusable transformations? |
| What are the joiner caches? |
| What are different options uses to configure the sequential batches? |
| What is a aggregator cache in aggregate transformation? |
| What is data cache and Index cache? |
| What is a Mapping Variable? |
| What are the types of mappings in Getting Started Wizard? |
| What are the data movement modes in Informatica? |
| What is the difference between partitioning of relational target and partitioning of file target? |
| What are the Transformations that restrict the partition of sessions? |
| What is a Power Center Repository? |
| Why we use stored procedure transformation? |
| Why we use partitioning the session in Informatica? |
| Why we use lookup transformation? |
| Why you use Repository connectivity? |
| Which join is not supported by Joiner Transformation? |
| Which Transformation is responsible to maintain updates in warehouse database? |
| Which transformation should we use to normalize the COBOL and relational sources? |
| How to implement Update Strategy? |
| How many ways your create ports? |
| How can you improve session performance in aggregator transformation? |
| How do you identify existing rows of data in the target table using lookup transformation? |
| How many ways you can create a Reusable Transformation? |
| When can session fail? |
| Where should you place the flat file to import the flat file definition to the designer? |
| Who is the first person in the organization to start the Data Warehouse project? |
| In which circumstances the Informatica creates a reject file (bad file)? |
| In a sequential batch can you run the session if previous session fails? |
| In which scenario does the Update Strategy Transformation is best suited? |
| After dragging the ports of three sources(sql server, oracle, Infomix) to a single source qualifier, can you map these three ports directly to target? |
| Can you use the mapping parameters or variables created in one mapping into any other reusable transformation? |
| Can you use the mapping parameters or variables created in one mapping into another mapping? |
| Can you start a session inside a batch individually? |
| Can you start batches with in a batch? |
| Can you generate reports in Informatica? |
| Can you copy the session to a different folder or Repository? |
| Performance tuning in Informatica? |
| To achieve the session partition what are the necessary tasks you have to do? |
| Types of Slowly Changing Dimensions: |
| We can stop the Batch by two ways: |
| While importing source definition the metadata that will be imported are: |
No comments:
Post a Comment