Q.What is target load order?
A.You specify the target loadorder based on source qualifiers in a maping.If you have the multiple source qualifiers connected to the multiple targets,You can designatethe order in which informatica server loads data into the targets.
A.You specify the target loadorder based on source qualifiers in a maping.If you have the multiple source qualifiers connected to the multiple targets,You can designatethe order in which informatica server loads data into the targets.
Q.How do you configure mapping in informatica?
A.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 links between transformations.For transformations that use data cache (such as Aggregator, Joiner, Rank, and Lookup transformations), limit connected input/output or output ports. Limiting the number of connected input/output or output ports reduces the amount of data the transformations store in the data cache.You can also perform the following tasks to optimize the mapping:
1.Configure single-pass reading.
2.Optimize datatype conversions.
3.Eliminate transformation errors.
4.Optimize transformations.
5.Optimize expressions.
A.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 links between transformations.For transformations that use data cache (such as Aggregator, Joiner, Rank, and Lookup transformations), limit connected input/output or output ports. Limiting the number of connected input/output or output ports reduces the amount of data the transformations store in the data cache.You can also perform the following tasks to optimize the mapping:
1.Configure single-pass reading.
2.Optimize datatype conversions.
3.Eliminate transformation errors.
4.Optimize transformations.
5.Optimize expressions.
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 links between transformations.For transformations that use data cache (such as Aggregator, Joiner, Rank, and Lookup transformations), limit connected input/output or output ports. Limiting the number of connected input/output or output ports reduces the amount of data the transformations store in the data cache.
Q..when conventional datawarehousing is able to handle and answer complex queries then what is the need of OLTP and OLAP?
A.
1.Designed for analysis of business measures by categories and attributes
2.Optimized for bulk loads and large, complex, unpredictable queries that access many rows per table.
3.Loaded with consistent, valid data; requires no real time validation
4.Supports few concurrent users relative to OLTP
A.
1.Designed for analysis of business measures by categories and attributes
2.Optimized for bulk loads and large, complex, unpredictable queries that access many rows per table.
3.Loaded with consistent, valid data; requires no real time validation
4.Supports few concurrent users relative to OLTP
Q.How can we join 3 database like Flat File, Oracle, Db2 in Informatrica.?
A.You have to use two joiner transformations.fIRST one will join two tables and the next one will join the third with the resultant of the first joiner.
A.You have to use two joiner transformations.fIRST one will join two tables and the next one will join the third with the resultant of the first joiner.
Q.How do you transfert the data from data warehouse to flatfile?
A.You can write a mapping with the flat file as a target using a DUMMY_CONNECTION. A flat file target is built by pulling a source into target space using Warehouse Designer tool.
A.You can write a mapping with the flat file as a target using a DUMMY_CONNECTION. A flat file target is built by pulling a source into target space using Warehouse Designer tool.
Q.How can u work with remote database in informatica?did u work directly by using remote connections?
A.You can work with remote,but you have to Configure FTP ,Connection details,IP address,User authentication.
A.You can work with remote,but you have to Configure FTP ,Connection details,IP address,User authentication.
Q.What is difference between IIF and DECODE function?
A.You can use nested IIF statements to test multiple conditions.
A.You can use nested IIF statements to test multiple conditions.
Q.What are the new features of the server manager in the informatica 5.0?
A.You can use command line arguments for a session or batch.This allows you to change the values of session parameters,and mapping parameters and maping variables.Parallel data processing: This feature is available for powercenter only.If we use the informatica server on a SMP system, You can use multiple CPU’s to process a session concurently.Process session data using threads: Informatica server runs the session in two processes.
A.You can use command line arguments for a session or batch.This allows you to change the values of session parameters,and mapping parameters and maping variables.Parallel data processing: This feature is available for powercenter only.If we use the informatica server on a SMP system, You can use multiple CPU’s to process a session concurently.Process session data using threads: Informatica server runs the session in two processes.
Q.Can we use aggregator/active transformation after update strategy transformation?
A.You can use aggregator after update strategy. The problem will be, once you perform the update strategy, say you had flagged some rows to be deleted and you had performed aggregator transformation for all rows, say you are using SUM function, then the deleted rows will be subtracted from this aggregator transformation.
A.You can use aggregator after update strategy. The problem will be, once you perform the update strategy, say you had flagged some rows to be deleted and you had performed aggregator transformation for all rows, say you are using SUM function, then the deleted rows will be subtracted from this aggregator transformation.
Q.what is the best way to show metadata(number of rows at source, target and each transformation level, error related data) in a report format?
A.You can select these details from the repository table. you can use the view REP_SESS_LOG to get these data.
A.You can select these details from the repository table. you can use the view REP_SESS_LOG to get these data.
Q.Can you start a batches with in a batch?
A.You can not. If you want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch.
A.You can not. If you want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch.
Q.How can you create or import flat file definition in to the warehouse designer?
A.You can not create or import flat file defintion in to warehouse designer directly.Instead you must analyze the file in source analyzer,then drag it into the warehouse designer.When you drag the flat file source defintion into warehouse desginer workspace,the warehouse designer creates a relational target defintion not a file defintion.If you want to load to a file,configure the session to write to a flat file.When the informatica server runs the session,it creates and loads the flat file.
A.You can not create or import flat file defintion in to warehouse designer directly.Instead you must analyze the file in source analyzer,then drag it into the warehouse designer.When you drag the flat file source defintion into warehouse desginer workspace,the warehouse designer creates a relational target defintion not a file defintion.If you want to load to a file,configure the session to write to a flat file.When the informatica server runs the session,it creates and loads the flat file.
Q.How to Generate the Metadata Reports in Informatica?
A.You can generate PowerCenter Metadata Reporter from a browser on any workstation, even a workstation that does not have PowerCenter tools installed.
A.You can generate PowerCenter Metadata Reporter from a browser on any workstation, even a workstation that does not have PowerCenter tools installed.
Q.What are the methods for creating reusable transforamtions?
A.You can design using 2 methods using transformation developer create normal one and promote it to reusable.
A.You can design using 2 methods using transformation developer create normal one and promote it to reusable.
Q.What are the diffrence between joiner transformation and source qualifier transformation?
A.You can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation.You need matching keys to join two relational sources in source qualifier transformation.Where as you doesn’t need matching keys to join two sources.Two relational sources should come from same datasource in sourcequalifier.You can join relatinal sources which are coming from diffrent sources also.Can any body write a session parameter file which will change the source and targets for every session. i.e different source and targets for each session run.You are supposed to define a parameter file. And then in the Parameter file, you can define two parameters, one for source and one for target.
A.You can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation.You need matching keys to join two relational sources in source qualifier transformation.Where as you doesn’t need matching keys to join two sources.Two relational sources should come from same datasource in sourcequalifier.You can join relatinal sources which are coming from diffrent sources also.Can any body write a session parameter file which will change the source and targets for every session. i.e different source and targets for each session run.You are supposed to define a parameter file. And then in the Parameter file, you can define two parameters, one for source and one for target.
Q.In a sequential batch can you run the session if previous session fails?
A.Yes.By setting the option always runs the session.
A.Yes.By setting the option always runs the session.
Q.Can you use the maping parameters or variables created in one maping into any other reusable transformation?
A.Yes.Because reusable tranformation is not contained with any maplet or maping.
A.Yes.Because reusable tranformation is not contained with any maplet or maping.
Q.Can you generate reports in Informatcia?
A.Yes. By using Metadata reporter we can generate reports in informatica.There are 3 depts in dept table and one with 100 people and 2nd with 5 and 3rd with some 30 and so. i want to diplay those deptno where more than 10 people exists.If you want to perform it thru informatica, the Fire the same query in the SQL Override of Source qualifier transformation and make a simple pass thru mapping.Other wise, you can also do it by using a Filter.Router transformation by giving the condition there deptno>=10.
A.Yes. By using Metadata reporter we can generate reports in informatica.There are 3 depts in dept table and one with 100 people and 2nd with 5 and 3rd with some 30 and so. i want to diplay those deptno where more than 10 people exists.If you want to perform it thru informatica, the Fire the same query in the SQL Override of Source qualifier transformation and make a simple pass thru mapping.Other wise, you can also do it by using a Filter.Router transformation by giving the condition there deptno>=10.
Q.Can you copy the session to a different folder or repository?
A.Yes. By using copy session wizard You can copy a session in a different folder or repository. But that target folder or repository should consists of mapping of that session.If target folder or repository is not having the maping of copying session ,You should have to copy that maping first before you copy the session.
A.Yes. By using copy session wizard You can copy a session in a different folder or repository. But that target folder or repository should consists of mapping of that session.If target folder or repository is not having the maping of copying session ,You should have to copy that maping first before you copy the session.
Q.Can Informatica be used as a Cleansing Tool? If Yes, give example of transformations that can implement a data cleansing routine.
A.Yes, we can use Informatica for cleansing data. some time we use stages to cleansing the data. It depends upon performance again else we can use expression to cleasing data.For example an feild X have some values and other with Null values and assigned to target feild where target feild is notnull column, inside an expression we can assign space or some constant value to avoid session failure.The input data is in one format and target is in another format, we can change the format in expression.we can assign some default values to the target to represent complete set of data in the target.
A.Yes, we can use Informatica for cleansing data. some time we use stages to cleansing the data. It depends upon performance again else we can use expression to cleasing data.For example an feild X have some values and other with Null values and assigned to target feild where target feild is notnull column, inside an expression we can assign space or some constant value to avoid session failure.The input data is in one format and target is in another format, we can change the format in expression.we can assign some default values to the target to represent complete set of data in the target.
Q.Can batches be copied/stopped from server manager?
A.Yes, we can stop the batches using server manager or pmcmd command.
A.Yes, we can stop the batches using server manager or pmcmd command.
Q.Can Informatica load heterogeneous targets from heterogeneous sources?
A.Yes it can. For example...Flat File and Relations sources are joined in the mapping, and later, Flat File and relational targets are loaded.
A.Yes it can. For example...Flat File and Relations sources are joined in the mapping, and later, Flat File and relational targets are loaded.
Q.What is tracing level?
A.Its the level of information storage in session log.The option comes in the properties tab of transformations. By default it remains "Normal". Can be
1.Verbose Initialisation
2.Verbose Data
3.Normal
4.Terse
A.Its the level of information storage in session log.The option comes in the properties tab of transformations. By default it remains "Normal". Can be
1.Verbose Initialisation
2.Verbose Data
3.Normal
4.Terse
Q.Can we run a group of sessions without using workflow manager?
A.Its Posible using pmcmd Command with out using the workflow Manager run the group of session.
A.Its Posible using pmcmd Command with out using the workflow Manager run the group of session.
Q.How do you create single lookup transformation using multiple tables?
A.Write a override sql query. Adjust the ports as per the sql query.
A.Write a override sql query. Adjust the ports as per the sql query.
Q.How can we join the tables if the tables have no primary and forien key relation and no matchig port to join?
A.without common column or common data type we can join two sources using dummy ports.
1.Add one dummy port in two sources.
2.In the expression trans assing '1' to each port.
2.Use Joiner transformation to join the sources using dummy port(use join conditions).
A.without common column or common data type we can join two sources using dummy ports.
1.Add one dummy port in two sources.
2.In the expression trans assing '1' to each port.
2.Use Joiner transformation to join the sources using dummy port(use join conditions).
Q.Describe two levels in which update strategy transformation sets?
A.
1.Within a session: When you configure a session, You can instruct the Informatica Server to either treat all records in the same way (for example, treat all records as inserts), or use instructions coded into the session mapping to flag records for different database operations.
A.
1.Within a session: When you configure a session, You can instruct the Informatica Server to either treat all records in the same way (for example, treat all records as inserts), or use instructions coded into the session mapping to flag records for different database operations.
2.Within a mapping: Within a mapping, you use the Update Strategy transformation to flag records for insert, delete, update, or reject.
No comments:
Post a Comment