DataGenX - Atul's Blog: Scenario

Showing posts with label Scenario. Show all posts

DataStage Scenario #17 - Get Transitive relation between columns

December 22, 2016

Goal : To get the data from two columns which have transitive relationship between them A -> B B -> C then A -> C ...

Python Points #15 - Exceptions

September 12, 2016

Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.go...

Shell Script Scenario #8 - Odd and Even No

April 20, 2016

Write a shell script to find whether an input integer is even or odd. Like the below page to get update https:/...

10 Scenario based Interview Questions #2 - DataStage

April 18, 2016

11. Design a job which insert the data if not exists and update if exists in target 12. Design a job which includes a header and footer i...

DataStage Scenario #16 - Cross duplicate Removal

April 04, 2016

Need to remove duplicate where source or destination can be switched. Input: source destination distance cit...

10 Scenario based Interview Questions #1 - DataStage

March 28, 2016

1. Design a job which convert single source row to three target row. 2. Design a job which can identify the row if they are duplicate in i...

DataStage Scenario #15 - Get First & Last Date of Last Month

February 23, 2016

Design a job which can generate the First and Last date of Last Month and pass this into an SQL which executes inside a parallel job? ...

DataStage Scenario #14 - Get Day specific file

February 05, 2016

Hi Guys, Design jobs for one more realtime scenario - Requirement- Job will run once in a day, which read a file from a folder, but...

DataStage Scenario #13 - Validate Decimals

February 04, 2016

Input: Data 1 2 3 4. 345 423 4w 4232.23 42342.43243 56765.74 545 4 4o 646. 4343 3232. 4232 ...

Shell Script for getting lines after and before of search String

January 22, 2016

Sometime when we search some text string in Unix environment we need those strings also which come before or after that searched string. ...

DataStage Scenario #12 - Combine data column wise

January 13, 2016

Col1 Col2 Col3 1 2 3 4 5 6 7 8 9 Col4 Col5 Col6 a b ...

Cartesian Join - A Quick DataStage Recipe

January 11, 2016

What to Cook: How to do Cartesian join -> Join every row of a table to every row of other table Ingredients: Use "column...

DataStage Scenario #11 - Get numeric or alphabets only

December 11, 2015

Goal - Extract numeric part and alpha part from a string as below Input: Source ATUL1234 SINGH374 I23S ...

DataStage Scenario #10 - two realtime scenario

November 25, 2015

Hello guys, Hoping you are enjoying while solving DataStage Scenarios. Today I am going to ask two real time scenario. try to solve these ...

Shell Script Scenario #7 - Anagram words

November 15, 2015

Two words are called Anagram when you can rearrange the letters from one to spell the other. i.e. - Coat and Taco Heater and Reheat ...

DataStage Scenario #9 - Add Header & Trailer

November 09, 2015

Scenario: Design a job to add Header and Trailer to input data. Example Input: Atul Neeraj Anita A...

DataStage Scenario #8 - Populate date between given two

October 21, 2015

Scenario : Design a job with 2 job parameters - 1. Start Date ( DD-MM-YYYY ) 2. End Date ( DD-MM-YYYY ) Read the parameter a...

DataStage Scenario #7 - Count data in each column

October 14, 2015

Count the total rows and cells which is having some data in it. Input: col1 col2 col3 a {NULL} b ...

Shell Script Scenario #2 - Solution

October 07, 2015

You can find other scenarios HERE ================================================================================== ==============...

Shell Script Scenario #5 - Letters order

September 30, 2015

Design a script to get below output - Requirement - Check whether all the letters in word is in order or not. Data : almost cereal ...

Subscribe to: Posts ( Atom )

DataGenX - Atul's Blog