71. WHAT ARE THE TYPES OF MAPING IN GETTING STARTED WIZARD?
Simple Pass through maping : Loads a static fact or dimension table by inserting all rows. Use this mapping when you want to drop all existing data from your table before loading new data. Slowly Gr
72. IN A SCENARIO I HAVE COL1, COL2, COL3, UNDER THAT 1,X,Y, AND 2,A,B AND I WANT IN THIS FORM COL1, COL2 AND 1,X AND 1,Y AND 2,A AND 2,B, WHAT IS THE PROCEDURE?
Use Normalizer : create two ports - first port occurs = 1 second make occurs = 2 two output ports are created and connect to target
73. HOW CAN YOU IMPROVE THE PERFORMANCE OF AGGREGATE TRANSFORMATION?
We can improve the aggregator performance in the following ways 1.send sorted input. 2.increase aggregator cache size. i.e. Index cache and data cache. 3.Give input/output what you need in th
74. WHERE TO STORE INFORMATICA REJECTED DATA? HOW TO EXTRACT THE INFORMATICA REJECTED DATA?
The reject rows say for example due to unique key constrain is all pushed by session into the $PMBadFileDir (default relative path is
75. IN A SEQUENTIAL BATCH HOW CAN WE STOP SINGLE SESSION?
We can stop it using PMCMD command or in the monitor right click on that perticular session and select stop.this will stop the current session and the sessions next to it.
76. HOW DO YOU CREATE SINGLE LOOKUP TRANSFORMATION USING MULTIPLE TABLES?
Write a override sql query. Adjust the ports as per the sql query.
77. WHAT R THE MAPINGS THAT WE USE FOR SLOWLY CHANGING DIMENSION TABLE?
We can use the following Mapping for slowly Changing dimension table. Expression Lookup Filter Sequence Generator Update Strategy
78. IN WHICH CONDITIONS WE CANNOT USE JOINER TRANSFORMATION (LIMITATIONS OF JOINER TRANSFORMATION)?
Both pipelines begin with the same original data source. Both input pipelines originate from the same Source Qualifier transformation. Both input pipelines originate from the same Normalizer transfo
79. WHAT IS BATCH AND DESCRIBE ABOUT TYPES OF BATCHES?
There are two types of batches 1. Concurrent 2. Sequential
80. WHAT IS THE PROCEDURE TO LOAD THE FACT TABLE? GIVE IN DETAIL?
Based on the requirement to your fact table, choose the sources and data and transform it based on your business needs. For the fact table, you need a primary key so use a sequence generator transfo
Simple Pass through maping : Loads a static fact or dimension table by inserting all rows. Use this mapping when you want to drop all existing data from your table before loading new data. Slowly Gr
72. IN A SCENARIO I HAVE COL1, COL2, COL3, UNDER THAT 1,X,Y, AND 2,A,B AND I WANT IN THIS FORM COL1, COL2 AND 1,X AND 1,Y AND 2,A AND 2,B, WHAT IS THE PROCEDURE?
Use Normalizer : create two ports - first port occurs = 1 second make occurs = 2 two output ports are created and connect to target
73. HOW CAN YOU IMPROVE THE PERFORMANCE OF AGGREGATE TRANSFORMATION?
We can improve the aggregator performance in the following ways 1.send sorted input. 2.increase aggregator cache size. i.e. Index cache and data cache. 3.Give input/output what you need in th
74. WHERE TO STORE INFORMATICA REJECTED DATA? HOW TO EXTRACT THE INFORMATICA REJECTED DATA?
The reject rows say for example due to unique key constrain is all pushed by session into the $PMBadFileDir (default relative path is
75. IN A SEQUENTIAL BATCH HOW CAN WE STOP SINGLE SESSION?
We can stop it using PMCMD command or in the monitor right click on that perticular session and select stop.this will stop the current session and the sessions next to it.
76. HOW DO YOU CREATE SINGLE LOOKUP TRANSFORMATION USING MULTIPLE TABLES?
Write a override sql query. Adjust the ports as per the sql query.
77. WHAT R THE MAPINGS THAT WE USE FOR SLOWLY CHANGING DIMENSION TABLE?
We can use the following Mapping for slowly Changing dimension table. Expression Lookup Filter Sequence Generator Update Strategy
78. IN WHICH CONDITIONS WE CANNOT USE JOINER TRANSFORMATION (LIMITATIONS OF JOINER TRANSFORMATION)?
Both pipelines begin with the same original data source. Both input pipelines originate from the same Source Qualifier transformation. Both input pipelines originate from the same Normalizer transfo
79. WHAT IS BATCH AND DESCRIBE ABOUT TYPES OF BATCHES?
There are two types of batches 1. Concurrent 2. Sequential
80. WHAT IS THE PROCEDURE TO LOAD THE FACT TABLE? GIVE IN DETAIL?
Based on the requirement to your fact table, choose the sources and data and transform it based on your business needs. For the fact table, you need a primary key so use a sequence generator transfo
More Questions & Answers :-
No comments:
Post a Comment