Q.Why use the lookup transformation?
A.To perform the following tasks:-
Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target table to make your summary data easier to read.Perform a calculation. Many normalized tables include values used in a calculation, such as gross sales per invoice or sales tax, but not the calculated value (such as netsales).Update slowly changing dimension tables.
A.To perform the following tasks:-
Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target table to make your summary data easier to read.Perform a calculation. Many normalized tables include values used in a calculation, such as gross sales per invoice or sales tax, but not the calculated value (such as netsales).Update slowly changing dimension tables.
Q.Explain use of update strategy transformation
A.To flag source records as INSERT, DELETE, UPDATE or REJECT for target database. Default flag is Insert. This is must for Incremental Data Loading.
A.To flag source records as INSERT, DELETE, UPDATE or REJECT for target database. Default flag is Insert. This is must for Incremental Data Loading.
Q.How do you load the time dimension.
A.Time Dimension will generally load manually by using PL/SQL , shell scripts, proc C etc.
A.Time Dimension will generally load manually by using PL/SQL , shell scripts, proc C etc.
Q.What are the types of data that passes between informatica server and stored procedure?
A.Three types of data:-
1.Input/Out put parameters
2.Return Values
3.Status code.
A.Three types of data:-
1.Input/Out put parameters
2.Return Values
3.Status code.
Q.What is update strategy transformation?
A.This transformation is used to maintain the history data or just most recent changes in to target table.
A.This transformation is used to maintain the history data or just most recent changes in to target table.
Q.Why sorter transformation is an active transformation?
A.This is type of active transformation which is responsible for sorting the data either in the ascending order or descending order according to the key specifier. the port on which the sorting takes place is called as sortkeyport properties.if we select distinct eliminate duplicates case sensitive valid for strings to sort the data null treated low null values are given least priority
A.This is type of active transformation which is responsible for sorting the data either in the ascending order or descending order according to the key specifier. the port on which the sorting takes place is called as sortkeyport properties.if we select distinct eliminate duplicates case sensitive valid for strings to sort the data null treated low null values are given least priority
Q.How many types of dimensions are available in informatica?
A.There r 3 types of dimensions
1.star schema
2.snowflake schema
3.glaxy schema
A.There r 3 types of dimensions
1.star schema
2.snowflake schema
3.glaxy schema
Q.Where should U place the flat file to import the flat file defintion to the designer?
A.There is no such restrication to place the source file. In performance point of view its better to place the file in server local src folder. if you need path please check the server properties availble at workflow manager.It doesn't mean we should not place in any other folder, if we place in server src folder by default src will be selected at time session creation.
A.There is no such restrication to place the source file. In performance point of view its better to place the file in server local src folder. if you need path please check the server properties availble at workflow manager.It doesn't mean we should not place in any other folder, if we place in server src folder by default src will be selected at time session creation.
Q.What is difference b/w Informatica 7.1 and Abinitio
A.There is a lot of diffrence between informatica an Ab Initio.In Ab Initio we r using 3 parllalisim but Informatica using 1 parllalisim
In Ab Initio no scheduling option we can scheduled manully or pl/sql script but informatica contains 4 scheduling options.Ab Inition contains co-operating system but informatica is not.Ramp time is very quickly in Ab Initio campare than Informatica Ab Initio is userfriendly than Informatica.
A.There is a lot of diffrence between informatica an Ab Initio.In Ab Initio we r using 3 parllalisim but Informatica using 1 parllalisim
In Ab Initio no scheduling option we can scheduled manully or pl/sql script but informatica contains 4 scheduling options.Ab Inition contains co-operating system but informatica is not.Ramp time is very quickly in Ab Initio campare than Informatica Ab Initio is userfriendly than Informatica.
Q.How many types of facts and what are they?
A.There are
1.Factless Facts:Facts without any measures.
2.Additive Facts:Fact data that can be additive/aggregative.
3.Non-Additive facts: Facts that are result of non-additon
4.Semi-Additive Facts: Only few colums data can be added.
5.Periodic Facts: That stores only one row per transaction that happend over a period of time.
6.Accumulating Fact: stores row for entire lifetime of event.
A.There are
1.Factless Facts:Facts without any measures.
2.Additive Facts:Fact data that can be additive/aggregative.
3.Non-Additive facts: Facts that are result of non-additon
4.Semi-Additive Facts: Only few colums data can be added.
5.Periodic Facts: That stores only one row per transaction that happend over a period of time.
6.Accumulating Fact: stores row for entire lifetime of event.
Q.How to use the unconnected lookup i.e., from where the input has to be taken and the output is linked?
A.The unconnected lookup is used just like a function call. in an expression output/variable port or any place where an expression is accepted(like condition in update strategy etc..), call the unconnected lookup...something like :LKP.lkp_abc(input_port).(lkp_abc is the name of the unconnected lookup gives the input value just like we pass parameters to functions, and it'll return the output after looking up.
A.The unconnected lookup is used just like a function call. in an expression output/variable port or any place where an expression is accepted(like condition in update strategy etc..), call the unconnected lookup...something like :LKP.lkp_abc(input_port).(lkp_abc is the name of the unconnected lookup gives the input value just like we pass parameters to functions, and it'll return the output after looking up.
Q.What are the circumstances that infromatica server results an unreciverable session?
A.
1.The source qualifier transformation does not use sorted ports.
2.If we change the partition information after the initial session fails.
3.Perform recovery is disabled in the informatica server configuration.
4.If the sources or targets changes after initial session fails.
5.If the maping consists of sequence generator or normalizer transformation.
6.If a concuurent batche contains multiple failed sessions.
A.
1.The source qualifier transformation does not use sorted ports.
2.If we change the partition information after the initial session fails.
3.Perform recovery is disabled in the informatica server configuration.
4.If the sources or targets changes after initial session fails.
5.If the maping consists of sequence generator or normalizer transformation.
6.If a concuurent batche contains multiple failed sessions.
Q.What is power center repository?
A.The PowerCenter repository allows you to share metadata across repositories to create a data mart domain. In a data mart domain, yoYou can create a single global repository to store metadata used across an enterprise, and a number of local repositories to share the global metadata as needed.
A.The PowerCenter repository allows you to share metadata across repositories to create a data mart domain. In a data mart domain, yoYou can create a single global repository to store metadata used across an enterprise, and a number of local repositories to share the global metadata as needed.
Q.Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
A.The only two possibilities are:
1.Both the table should have primary key/foreign key relation ship
2.Both the table should be available in the same schema or same database
A.The only two possibilities are:
1.Both the table should have primary key/foreign key relation ship
2.Both the table should be available in the same schema or same database
Q.Which transformation should we use to normalize the COBOL and relational sources?
A.The Normalizer transformation normalizes records from COBOL and relational sources, allowing you to organize the data according to your own needs. A Normalizer transformation can appear anywhere in a data flow when you normalize a relational source. Use a Normalizer transformation instead of the Source Qualifier transformation when you normalize a COBOL source. When you drag a COBOL source into the Mapping Designer workspace, the Normalizer transformation automatically appears, creating input and output ports for every column in the source
A.The Normalizer transformation normalizes records from COBOL and relational sources, allowing you to organize the data according to your own needs. A Normalizer transformation can appear anywhere in a data flow when you normalize a relational source. Use a Normalizer transformation instead of the Source Qualifier transformation when you normalize a COBOL source. When you drag a COBOL source into the Mapping Designer workspace, the Normalizer transformation automatically appears, creating input and output ports for every column in the source
Q.What are the Differences between Informatica Power Center versions 6.2 and 7.1, also between Versions 6.2 and 5.1?
A.The main difference between informatica 5.1 and 6.1 is that in 6.1 they introduce a new thing called repository server and in place of server manager(5.1), they introduce workflow manager and workflow monitor.
A.The main difference between informatica 5.1 and 6.1 is that in 6.1 they introduce a new thing called repository server and in place of server manager(5.1), they introduce workflow manager and workflow monitor.
Q.What is Load Manager?
A.The load Manager is the Primary Informatica Server Process. It performs the following tasks:-
1.Manages session and batch scheduling.
2.Locks the session and read session properties.
3.Reads the parameter file.
4.Expand the server and session variables and parameters.
5.Verify permissions and privileges.
6.Validate source and target code pages.
7.Create the session log file.
8.Create the Data Transformation Manager which execute the session.
A.The load Manager is the Primary Informatica Server Process. It performs the following tasks:-
1.Manages session and batch scheduling.
2.Locks the session and read session properties.
3.Reads the parameter file.
4.Expand the server and session variables and parameters.
5.Verify permissions and privileges.
6.Validate source and target code pages.
7.Create the session log file.
8.Create the Data Transformation Manager which execute the session.
Q.What is the default join that source qualifier provides?
A.The Joiner transformation supports the following join types, which you set in the Properties tab:
1.Normal (Default)
2.Master Outer
3.Detail Outer
4.Full Outer
A.The Joiner transformation supports the following join types, which you set in the Properties tab:
1.Normal (Default)
2.Master Outer
3.Detail Outer
4.Full Outer
Q.How can we partition a session in Informatica?
A.The Informatica® PowerCenter® Partitioning option optimizes parallel processing on multiprocessor hardware by providing a thread-based architecture and built-in data partitioning.GUI-based tools reduce the development effort necessary to create data partitions and streamline ongoing troubleshooting and performance tuning tasks, while ensuring data integrity throughout the execution process. As the amount of data within an organization expands and real-time demand for information grows, the PowerCenter Partitioning option enables hardware and applications to provide outstanding performance and jointly scale to handle large volumes of data and users.
A.The Informatica® PowerCenter® Partitioning option optimizes parallel processing on multiprocessor hardware by providing a thread-based architecture and built-in data partitioning.GUI-based tools reduce the development effort necessary to create data partitions and streamline ongoing troubleshooting and performance tuning tasks, while ensuring data integrity throughout the execution process. As the amount of data within an organization expands and real-time demand for information grows, the PowerCenter Partitioning option enables hardware and applications to provide outstanding performance and jointly scale to handle large volumes of data and users.
Q.What is Datadriven?
A.The Informatica Server follows instructions coded into Update Strategy transformations within the session mapping to determine how to flag rows for insert, delete, update, or reject.If the mapping for the session contains an Update Strategy transformation, this field is marked Data Driven by default.
A.The Informatica Server follows instructions coded into Update Strategy transformations within the session mapping to determine how to flag rows for insert, delete, update, or reject.If the mapping for the session contains an Update Strategy transformation, this field is marked Data Driven by default.
Q.What is meant by lookup caches?
A.The informatica server builds a cache in memory when it processes the first row af a data in a cached look up transformation.It allocates memory for the cache based on the amount you configure in the transformation or session properties.The informatica server stores condition values in the index cache and output values in the data cache.
A.The informatica server builds a cache in memory when it processes the first row af a data in a cached look up transformation.It allocates memory for the cache based on the amount you configure in the transformation or session properties.The informatica server stores condition values in the index cache and output values in the data cache.
Q.Define Informatica Repository?
A.The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools. Metadata can include information such as mappings describing how to transform source data, sessions indicating when you want the Informatica Server to perform the transformations, and connect strings for sources and targets.The repository also stores administrative information such as usernames and passwords, permissions and privileges, and product version.Use repository manager to create the repository.The Repository Manager connects to the repository database and runs the code needed to create the repositorytables.Thsea tables stores metadata in specific format the informatica server,client tools use.
A.The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools. Metadata can include information such as mappings describing how to transform source data, sessions indicating when you want the Informatica Server to perform the transformations, and connect strings for sources and targets.The repository also stores administrative information such as usernames and passwords, permissions and privileges, and product version.Use repository manager to create the repository.The Repository Manager connects to the repository database and runs the code needed to create the repositorytables.Thsea tables stores metadata in specific format the informatica server,client tools use.
No comments:
Post a Comment