ETL
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. Input : chennai bangalore 300 bangalore chennai 300 chennai bangalore 300 chennai trichy 200 trichy chennai 200 Output : chennai trichy 200 bangalore chennai 300 Code - Input File --> Reformat --> Sort --> Dedup Sort --> Output File Input File dml - record string(" ") city_1;