Posts

Showing posts from June, 2023

ETL

Image
    Abinitio Scenario's 1. Read each value and find sum. Input             12345             1234             123             12             1 Output             15             10             6             3             1 Code -  Input File --> Reformat --> Output File 2. Find the sum of runs in each over. Input Output Code -  Input File --> Rollup with key Change option --> Output File 3.   Concatenate the over value according to the given runs. Input Output Code -  Input File --> Reformat --> Output File 4...