21. HOW DO YOU CONFIGURE MAPPING IN INFORMATICA
You should configure the mapping with the least number of transformations and expressions to do the most amount of work possible. You should minimize the amount of data moved by deleting unnecessary.
22. HOW CAN WE USE PMCMD COMMAND IN A WORKFLOW OR TO RUN A SESSION?
in the command task there is a option pression. we can write appropriate command of pmcmd to run workflow.
23. WHAT ARE THE OUTPUT FILES THAT THE INFORMATICA SERVER CREATES DURING THE SESSION RUNNING?
Informatica server log: Informatica server(on unix) creates a log for all status and error messages(default name: pm.server.log). It also creates an error log for error messages. These files will b
24. IN DIMENSIONAL MODELING FACT TABLE IS NORMALIZED OR DENORMALIZED? IN CASE OF STAR SCHEMA AND INCASE OF SNOW FLAKE SCHEMA?
In Dimensional modeling, Star Schema: A Single Fact table will be surrounded by a group of Dimensional tables comprise of de- normalized data Snowflake Schema: A Single Fact table will be surrounded b
25. DISCUSS THE ADVANTAGES & DISADVANTAGES OF STAR & SNOWFLAKE SCHEMA?
In a STAR schema there is no relation between any two dimension tables, whereas in a SNOWFLAKE schema there is a possible relation between the dimension tables.
26. HOW MANY TYPES OF FACTS AND WHAT ARE THEY?
There are Factless Facts:Facts without any measures. Additive Facts:Fact data that can be additive/aggregative. Non-Additive facts: Facts that are result of non-additon Semi-Additive Facts: Only
27. WHAT IS SOURCE QUALIFIER TRANSFORMATION?
SQ transformation is a transformation which is automatically generated to read data from source tables into informatica designer.
28. WHEN DO U USE A UNCONNECTED LOOKUP AND CONNECTED LOOKUP.... WHAT IS THE DIFFERENCE BETWEEN DYNAMIC AND STATIC LOOKUP...Y AND WHEN DO V USE THESE TYPES OF LOOKUPS (I.E. DYNAMIC AND STATIC)
In static lookup cache, you cache all the lookup data at the starting of the session. in dynamic lookup cache, you go and query the database to get the lookup value for each record which needs the loo
29. WHICH TASKS CAN BE PERFORMED ON PORT LEVEL (USING ONE SPECIFIC PORT)?
I think unconnected Lookup or expression transformation can be used for single port for a row.
30. HOW CAN U WORK WITH REMOTE DATABASE IN INFORMATICA? DID U WORK DIRECTLY BY USING REMOTE CONNECTIONS?
To work with remote datasource u need to connect it with remote connections.But it is not preferable to work with that remote source directly by using remote connections .Instead u bring that source.
You should configure the mapping with the least number of transformations and expressions to do the most amount of work possible. You should minimize the amount of data moved by deleting unnecessary.
22. HOW CAN WE USE PMCMD COMMAND IN A WORKFLOW OR TO RUN A SESSION?
in the command task there is a option pression. we can write appropriate command of pmcmd to run workflow.
23. WHAT ARE THE OUTPUT FILES THAT THE INFORMATICA SERVER CREATES DURING THE SESSION RUNNING?
Informatica server log: Informatica server(on unix) creates a log for all status and error messages(default name: pm.server.log). It also creates an error log for error messages. These files will b
24. IN DIMENSIONAL MODELING FACT TABLE IS NORMALIZED OR DENORMALIZED? IN CASE OF STAR SCHEMA AND INCASE OF SNOW FLAKE SCHEMA?
In Dimensional modeling, Star Schema: A Single Fact table will be surrounded by a group of Dimensional tables comprise of de- normalized data Snowflake Schema: A Single Fact table will be surrounded b
25. DISCUSS THE ADVANTAGES & DISADVANTAGES OF STAR & SNOWFLAKE SCHEMA?
In a STAR schema there is no relation between any two dimension tables, whereas in a SNOWFLAKE schema there is a possible relation between the dimension tables.
26. HOW MANY TYPES OF FACTS AND WHAT ARE THEY?
There are Factless Facts:Facts without any measures. Additive Facts:Fact data that can be additive/aggregative. Non-Additive facts: Facts that are result of non-additon Semi-Additive Facts: Only
27. WHAT IS SOURCE QUALIFIER TRANSFORMATION?
SQ transformation is a transformation which is automatically generated to read data from source tables into informatica designer.
28. WHEN DO U USE A UNCONNECTED LOOKUP AND CONNECTED LOOKUP.... WHAT IS THE DIFFERENCE BETWEEN DYNAMIC AND STATIC LOOKUP...Y AND WHEN DO V USE THESE TYPES OF LOOKUPS (I.E. DYNAMIC AND STATIC)
In static lookup cache, you cache all the lookup data at the starting of the session. in dynamic lookup cache, you go and query the database to get the lookup value for each record which needs the loo
29. WHICH TASKS CAN BE PERFORMED ON PORT LEVEL (USING ONE SPECIFIC PORT)?
I think unconnected Lookup or expression transformation can be used for single port for a row.
30. HOW CAN U WORK WITH REMOTE DATABASE IN INFORMATICA? DID U WORK DIRECTLY BY USING REMOTE CONNECTIONS?
To work with remote datasource u need to connect it with remote connections.But it is not preferable to work with that remote source directly by using remote connections .Instead u bring that source.
More Questions & Answers :-
No comments:
Post a Comment