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

 

Senario 22

Demonstrate Incremental Aggregation.

Senario 21

Demonstrate Incremental load.

Senario 20

How to load multiple files with different structure.

Senario 19

Add custom message to session log file.

Senario 18

1. Count the no of vowel present in emp_name column

Senario 17

Insert and reject records using update strategy

Senario 16

Minus operation on flat file

Senario 15

sending data one after another to three tables in cyclic order 

Senario 14

Removing '$' symbol from salary column 

Senario 13

Using mapping parameter and variable in mapping

Senario 12

Produce files as target with dynamic names 

Senario 11

Lead and Lag in informatica level.

Senario 10

Concatenation of duplicate value by comma separation 

Senario 8

Extracting every nth row