Tally ERP 6.8
Tally ERP Tutorials...
Coming Soon..
Course Contents : From basics to GSTR fillings in Day Wise Schedule.
Course Contents : From basics to GSTR fillings in Day Wise Schedule.
Target Load Order/ Target Load Plan in Informatica
Target Load Order/ Target Load Plan in Informatica
Target load order (or) Target load plan is used to specify the order in which the integration service loads the targets. You can specify a target load order based on the source qualifier transformations in a mapping. If you have multiple source qualifier transformations connected to multiple targets, you can specify the order in which the integration service loads the data into the targets.
Target Load Order Group:
A target load order group is the collection of source qualifiers, transformations and targets linked in a mapping. The integration service reads the target load order group concurrently and it processes the target load order group sequentially.
Use of Target Load Order:
Target load order will be useful when the data of one target depends on the data of another target. For example, the employees table data depends on the departments data because of the primary-key and foreign-key relationship.
E.g.The departments table should be loaded first and then the employees table. Target load order is useful when you want to maintain referential integrity when inserting, deleting or updating tables that have the primary key and foreign key constraints.
Senario 9
Sending records to target tables in cyclic order
Senario 7
Get top 5 records to target without using rank
Senario 6
Sending alternate record to target
Senario 5
Sending first half record to one target and second half of record to another target
Senario 4
Remove header and footer from your file
Solution:
We can remove header by skipping 1st row while importing the source but for footer we will have to implement a logic as follows:
Solution:
We can remove header by skipping 1st row while importing the source but for footer we will have to implement a logic as follows:
- Use Expression Transformatin to assign Sequence no to each rows.
- Use Sorter after expression and sort on sequence no generated in expression transformation.
- as we have five footer lines use a filter after sorter and give condition where sequence no >5
- finally connect to the target.
Senario 3
Retrieving first and last record from a table/file
Senario 2
- Separating duplicate and non-duplicate rows to separate tables.
Solution: This can be achivied through this way :
After SQ use Aggregator Transformation and add a port o_COUNT of variable type with valueas COUNT(ID), Select group by all ports.Take a Router Transformation drag all ports from Aggregator and create two groups with following conditions:Unique = o_COUNT=1Duplicate=o_COUNT>1Connect the respective groups to their targets.Video :
Senario 1
Convert single row from source to three rows in target.
Solution : Let's assume our Source and Target structures are as following:
A) By using Java Transformation
Use Java Transformation after SQ and drag all ports to Java Transformation,then create output ports for o_ID,o_NAME, o_SALARY and write following codes in java code :
Compile the code and connect output ports to target.
Solution : Let's assume our Source and Target structures are as following:
A) By using Java Transformation
Use Java Transformation after SQ and drag all ports to Java Transformation,then create output ports for o_ID,o_NAME, o_SALARY and write following codes in java code :
Senario 32
Error Handling
Senario 31
Unit Testing
Senario 30
SCD Type3
Senario 29
SCD Type2
Senario 28
SCD TYPE1
Senario 27
Constraint Based Loading
Senario 26
Column to Rows Conversion
Senario 25
Rows to column conversion
Senario 24
Concurrent execution of a workflow.
Senario 23
Separate even odd records
