Q.How can you improve session performance in aggregator transformation?
A.Use sorted input.
A.Use sorted input.
Q.What is the look up transformation?
A.Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym.Informatica server queries the look up table based on the lookup ports in the transformation.It compares the lookup transformation port values to lookup table column values based on the look up condition.
A.Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym.Informatica server queries the look up table based on the lookup ports in the transformation.It compares the lookup transformation port values to lookup table column values based on the look up condition.
Q.How to get two targets T1 containing distinct values and T2 containing duplicate values from one source S1.
A.Use filter transformation for loading the target with no duplicates. and for the other transformation load it directly from source.
A.Use filter transformation for loading the target with no duplicates. and for the other transformation load it directly from source.
Q.How to delete duplicate rows in flat files source is any option in informatica
A.Use a sorter transformation , in that u will have a "distinct" option make use of it .When we create a target as flat file and source as oracle.. how can i specify first rows as column names in flat files.use a pre sql statement,but this is a hardcoding method...if you change the column names or put in extra columns in the flat file, you will have to change the insert statement
A.Use a sorter transformation , in that u will have a "distinct" option make use of it .When we create a target as flat file and source as oracle.. how can i specify first rows as column names in flat files.use a pre sql statement,but this is a hardcoding method...if you change the column names or put in extra columns in the flat file, you will have to change the insert statement
Q.Why did you use stored procedure in your ETL Application?
A.usage of stored procedure has the following advantages
1.checks the status of the target database
2.drops and recreates indexes
3.determines if enough space exists in the database
4.performs aspecilized calculation
A.usage of stored procedure has the following advantages
1.checks the status of the target database
2.drops and recreates indexes
3.determines if enough space exists in the database
4.performs aspecilized calculation
Q.why did u use update stategy in your application?
A.Update Strategy is used to drive the data to be Inert, Update and Delete depending upon some condition. You can do this on session level tooo but there you cannot define any condition.For eg: If you want to do update and insert in one mapping...you will create two flows and will make one as insert and one as update depending upon some condition.Refer : Update Strategy in Transformation Guide for more information
A.Update Strategy is used to drive the data to be Inert, Update and Delete depending upon some condition. You can do this on session level tooo but there you cannot define any condition.For eg: If you want to do update and insert in one mapping...you will create two flows and will make one as insert and one as update depending upon some condition.Refer : Update Strategy in Transformation Guide for more information
What are the options in the target session of update strategy transsformatioin?
A.1.Update as Insert:This option specified all the update records from source to be flagged as inserts in the target. In other words, instead of updating the records in the target they are inserted as new records.
2.Update else Insert:
This option enables informatica to flag the records either for update if they are old or insert, if they are new records from source.
A.1.Update as Insert:This option specified all the update records from source to be flagged as inserts in the target. In other words, instead of updating the records in the target they are inserted as new records.
2.Update else Insert:
This option enables informatica to flag the records either for update if they are old or insert, if they are new records from source.
Q.How do we do unit testing in informatica?
A.Unit testing are of two types
1.Quantitaive testing
2.Qualitative testing
Steps.
1.First validate the mapping
2.Create session on themapping and then run workflow.
Once the session is succeeded the right click on session and go for statistics tab.There you can see how many number of source rows are applied and how many number of rows loaded in to targets and how many number of rows rejected.This is called Quantitative testing.If once rows are successfully loaded then we will go for qualitative testing.
Steps
1.Take the DATM(DATM means where all business rules are mentioned to the corresponding source columns) and check whether the data is loaded according to the DATM in to target table.If any data is not loaded according to the DATM then go and check in the code and rectify it.This is called Qualitative testing.
This is what a devloper will do in Unit Testing.
A.Unit testing are of two types
1.Quantitaive testing
2.Qualitative testing
Steps.
1.First validate the mapping
2.Create session on themapping and then run workflow.
Once the session is succeeded the right click on session and go for statistics tab.There you can see how many number of source rows are applied and how many number of rows loaded in to targets and how many number of rows rejected.This is called Quantitative testing.If once rows are successfully loaded then we will go for qualitative testing.
Steps
1.Take the DATM(DATM means where all business rules are mentioned to the corresponding source columns) and check whether the data is loaded according to the DATM in to target table.If any data is not loaded according to the DATM then go and check in the code and rectify it.This is called Qualitative testing.
This is what a devloper will do in Unit Testing.
Q.How can u complete unrcoverable sessions?
A.Under certain circumstances, when a session does not complete, you need to truncate the target tables and run the session from the beginning. Run the session from the beginning when the Informatica Server cannot run recovery or when running recovery might result in inconsistent data.
A.Under certain circumstances, when a session does not complete, you need to truncate the target tables and run the session from the beginning. Run the session from the beginning when the Informatica Server cannot run recovery or when running recovery might result in inconsistent data.
Q.What is the difference between connected and unconnected stored procedures?
A.
1.Unconnected:
The unconnected Stored Procedure transformation is not connected directly to the flow of the mapping. It either runs before or after the session, or is called by an expression in another transformation in the mapping.
2.connected:
The flow of data through a mapping in connected mode also passes through the Stored Procedure transformation. All data entering the transformation through the input ports affects the stored procedure. You should use a connected Stored Procedure transformation when you need data from an input port sent as an input parameter to the stored procedure, or the results of a stored procedure sent as an output parameter to another transformation.
A.
1.Unconnected:
The unconnected Stored Procedure transformation is not connected directly to the flow of the mapping. It either runs before or after the session, or is called by an expression in another transformation in the mapping.
2.connected:
The flow of data through a mapping in connected mode also passes through the Stored Procedure transformation. All data entering the transformation through the input ports affects the stored procedure. You should use a connected Stored Procedure transformation when you need data from an input port sent as an input parameter to the stored procedure, or the results of a stored procedure sent as an output parameter to another transformation.
Q.Can we eliminate duplicate rows by using filter and router transformation ?
A.we can use SQL query for uniqness if the source is Relational.But if the source is Flat file then u should use Shorter or Aggregatot transformation
A.we can use SQL query for uniqness if the source is Relational.But if the source is Flat file then u should use Shorter or Aggregatot transformation
Q.Can we start a batches with in a batch?
A.We can not. If we want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch.
in the concept of mapping parameters and variables, the variable value will be saved to the repository after the completion of the session and the next time when u run the session, the server takes the saved variable value in the repository and starts assigning the next value of the saved value. for example i ran a session and in the end it stored a value of 50 to the repository.next time when i run the session, it should start with the value of 70. not with the value of 51.
Q.What are the different types of Type2 dimension maping?
A.Type2
1. Version number
2. Flag
3.Date
A.We can not. If we want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch.
in the concept of mapping parameters and variables, the variable value will be saved to the repository after the completion of the session and the next time when u run the session, the server takes the saved variable value in the repository and starts assigning the next value of the saved value. for example i ran a session and in the end it stored a value of 50 to the repository.next time when i run the session, it should start with the value of 70. not with the value of 51.
Q.What are the different types of Type2 dimension maping?
A.Type2
1. Version number
2. Flag
3.Date
Q.What are the mapings that we use for slowly changing dimension table?
A.
1.Type1: Rows containing changes to existing dimensions are updated in the target by overwriting the existing dimension. In the Type 1 Dimension mapping, all rows contain current dimension data.
Use the Type 1 Dimension mapping to update a slowly changing dimension table when you do not need to keep any previous versions of dimensions in the table.
2.Type 2: The Type 2 Dimension Data mapping inserts both new and changed dimensions into the target. Changes are tracked in the target table by versioning the primary key and creating a version number for each dimension in the table.Use the Type 2 Dimension/Version Data mapping to update a slowly changing dimension table when you want to keep a full history of dimension data in the table. Version numbers and versioned primary keys track the order of changes to each dimension.
3.Type 3: The Type 3 Dimension mapping filters source rows based on user-defined comparisons and inserts only those found to be new dimensions to the target. Rows containing changes to existing dimensions are updated in the target. When updating an existing dimension, the Informatica Server saves existing data in different columns of the same row and replaces the existing data with the updates.
A.
1.Type1: Rows containing changes to existing dimensions are updated in the target by overwriting the existing dimension. In the Type 1 Dimension mapping, all rows contain current dimension data.
Use the Type 1 Dimension mapping to update a slowly changing dimension table when you do not need to keep any previous versions of dimensions in the table.
2.Type 2: The Type 2 Dimension Data mapping inserts both new and changed dimensions into the target. Changes are tracked in the target table by versioning the primary key and creating a version number for each dimension in the table.Use the Type 2 Dimension/Version Data mapping to update a slowly changing dimension table when you want to keep a full history of dimension data in the table. Version numbers and versioned primary keys track the order of changes to each dimension.
3.Type 3: The Type 3 Dimension mapping filters source rows based on user-defined comparisons and inserts only those found to be new dimensions to the target. Rows containing changes to existing dimensions are updated in the target. When updating an existing dimension, the Informatica Server saves existing data in different columns of the same row and replaces the existing data with the updates.
Q.How many ways you create ports?
A.Two ways:-
1.Drag the port from another transforamtion
2.Click the add buttion on the ports tab.
A.Two ways:-
1.Drag the port from another transforamtion
2.Click the add buttion on the ports tab.
Q.How many ways you can update a relational source defintion and what are they?
a.Two ways:-
1. Edit the definition
2. Reimport the defintion.
a.Two ways:-
1. Edit the definition
2. Reimport the defintion.
Q.What are the basic needs to join two sources in a source qualifier?
A.
1.Two sources should have primary and Foreign key relation ships.
2.Two sources should have matching data types.
A.
1.Two sources should have primary and Foreign key relation ships.
2.Two sources should have matching data types.
Q.What are the different options used to configure the sequential batches?
A.Run the session only if previous session completes sucessfully. Always runs the session.
A.Run the session only if previous session completes sucessfully. Always runs the session.
Q.What are the methods for creating reusable transforamtions?
A.Two methods:-
1.Design it in the transformation developer.
2.Promote a standard transformation from the mapping designer.After you add a transformation to the mapping , You can promote it to the status of reusable transformation.
Once you promote a standard transformation to reusable status,You can demote it to a standard transformation at any time.If you change the properties of a reusable transformation in mapping,You can revert it to the original reusable transformation properties by clicking the revert button.
A.Two methods:-
1.Design it in the transformation developer.
2.Promote a standard transformation from the mapping designer.After you add a transformation to the mapping , You can promote it to the status of reusable transformation.
Once you promote a standard transformation to reusable status,You can demote it to a standard transformation at any time.If you change the properties of a reusable transformation in mapping,You can revert it to the original reusable transformation properties by clicking the revert button.
Q.What are the active and passive transforamtions?
A.Transformations can be active or passive. An active transformation can change the number of rows that pass through it, such as a Filter transformation that removes rows that do not meet the filter condition.A passive transformation does not change the number of rows that pass through it, such as an Expression transformation that performs a calculation on data and passes all rows through the transformation.
A.Transformations can be active or passive. An active transformation can change the number of rows that pass through it, such as a Filter transformation that removes rows that do not meet the filter condition.A passive transformation does not change the number of rows that pass through it, such as an Expression transformation that performs a calculation on data and passes all rows through the transformation.
Q.what are the types of tracing level?
A.Tracing level represents the amount of information that informatcia server writes in a log file.
Types of tracing level:-
1.Normal
2.Verbose
3.Verbose init
4.Verbose data
A.Tracing level represents the amount of information that informatcia server writes in a log file.
Types of tracing level:-
1.Normal
2.Verbose
3.Verbose init
4.Verbose data
Q.How can u work with remote database in informatica?did u work directly by using remote connections?
A.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 into U r local machine where informatica server resides.If u
work directly with remote source the session performance will decreases by passing less amount of data across the network in a particular time.
A.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 into U r local machine where informatica server resides.If u
work directly with remote source the session performance will decreases by passing less amount of data across the network in a particular time.
No comments:
Post a Comment