#Vsam files in informatica training how to
How to create target database by using front end.In Router T/R we can add multiple conditions.Note: One mapping contains any number of transformations Data types, source, table name, source column name. As per ETL mapping specification Document (Spec doc)Ĭontains details of the source each column description.ETL Specification Document (Mapping Specification Dec).Keep the filter T/R as close to the source Qualifier as possible to filter the rows early in the data flow, there by number of records are reduced for further processing.
It give the best result and performance is better. Some people suggested use filter T/R as close to source Qualifier.This design give accurate result but performance point of its not good.The sales dept unique identification number is 30. If salary is greater than 8000 calculate the tax as sal * 0.25 else calculate the tax as sal * 0.17 The power Centre Integration service ignores all text on a line preceded by these two Comments specifies.Ĭalculate the for an employees who belongs to sales department as follows, The transformation language provides two comments specifies to let you insert comments in expression Informatica power Centre – Comment lines: Any reusable expression we have to create variable port.Īny non reusable expression created in output port any reusable expression created in variable port. Any expression which is reusable such expression directly built in variable port. HRA IIF (Sal > 8000, sal * 0.25, sal * 0.15)Īny expression which is non reusable such expression directly built in output port. When to develop expression only in output port and when we develop expression in variable port?.Expression is passive T/R if process row by row that’s the reason expression receive all rows. We develop expression in expression T/R that’s why we use variable port.Īns. Expressions can be developed using functions and arithmetical operators.Īll transformation should have Input port and output port.Any expressions can be developed either in only output ports or variable ports.Any expression T/R is created with following types of the ports.An expression transaction is operated for each source row.This is a type of passive transformation which allows you to develop expressions and expressions are calculated on row by row base.Informatica supports always single line comment - or //.Decode() is more efficient compared with Nested If.In informatica use Decode () functions when we want to use Nested if.For unknown Gender in this situation we use nested if.Expression T/R is used process row by row.If condition (comm) is null return sal, otherwise return sal + comm. The project logics develop from expression,įor example: Total Sal for each Employee = sal + COMM (May having null values) We develop business rule through expression Transaction. In any domain (banking, telecom, retail, Insurance).What is cache? Why cache is need/ required? Without cache u requirement is process or not?.Filter T/R is a GUI, it function as where Clause in SQL.Note: TRUE is the default filter condition. In Filter T/R we use TRUE indicates all records load into target.I have a source with 10 rows I want to load all 10 records in the target using filter T/R.Īns: Using flat mapping also we can load all 10 records TRUE: Source row is satisfied with condition Any where we can’t capture rejected records.ģ. We can write only one condition in Filter T/RĢ. We can’t see the rejected records in bad file.ġ. * At runtime integration service evaluate conditionĪny possible to view the rejected in session log file? Can u see rejected records in bad file?Īns: Can’t view the rejected records in session log. My requirement specification I want to create multiple conditions?Īns: There is a way to create multiple conditions At a time we will not create 3 conditions. In this three conditions either we create only one condition. (Dept no= 30 OR Deptno =20) and Job = ‘Clark’ – Here We have 2 conditionsThere Is null (COMM) and sal > 8000 – Here we have 2 conditions 3000 and Job = ‘Manager’ – Here we have 2 conditions