DataStage Scenario #17 - Get Transitive relation between columns
Atul Singh
December 22, 2016
Goal : To get the data from two columns which have transitive relationship between them A -> B B -> C then A -> C ...
Showing posts with label Scenario. Show all posts
Showing posts with label Scenario. Show all posts
Thursday, 22 December 2016
Monday, 12 September 2016
Python Points #15 - Exceptions
Atul Singh
September 12, 2016
Like the below page to get update https://www.facebook.com/datastage4you https://twitter.com/datagenx https://plus.go...
Wednesday, 20 April 2016
Shell Script Scenario #8 - Odd and Even No
Atul Singh
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:/...
Monday, 18 April 2016
10 Scenario based Interview Questions #2 - DataStage
Atul Singh
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...
Monday, 4 April 2016
DataStage Scenario #16 - Cross duplicate Removal
Atul Singh
April 04, 2016
Need to remove duplicate where source or destination can be switched. Input: source destination distance cit...
Monday, 28 March 2016
10 Scenario based Interview Questions #1 - DataStage
Atul Singh
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...
Tuesday, 23 February 2016
DataStage Scenario #15 - Get First & Last Date of Last Month
Unknown
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? ...
Friday, 5 February 2016
DataStage Scenario #14 - Get Day specific file
Atul Singh
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...
Thursday, 4 February 2016
DataStage Scenario #13 - Validate Decimals
Unknown
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 ...
Friday, 22 January 2016
Shell Script for getting lines after and before of search String
Atul Singh
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. ...
Wednesday, 13 January 2016
DataStage Scenario #12 - Combine data column wise
Atul Singh
January 13, 2016
Col1 Col2 Col3 1 2 3 4 5 6 7 8 9 Col4 Col5 Col6 a b ...
Monday, 11 January 2016
Cartesian Join - A Quick DataStage Recipe
Atul Singh
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...
Friday, 11 December 2015
DataStage Scenario #11 - Get numeric or alphabets only
Atul Singh
December 11, 2015
Goal - Extract numeric part and alpha part from a string as below Input: Source ATUL1234 SINGH374 I23S ...
Wednesday, 25 November 2015
DataStage Scenario #10 - two realtime scenario
Atul Singh
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 ...
Sunday, 15 November 2015
Shell Script Scenario #7 - Anagram words
Atul Singh
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 ...
Monday, 9 November 2015
DataStage Scenario #9 - Add Header & Trailer
Atul Singh
November 09, 2015
Scenario: Design a job to add Header and Trailer to input data. Example Input: Atul Neeraj Anita A...
Wednesday, 21 October 2015
DataStage Scenario #8 - Populate date between given two
Atul Singh
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...
Wednesday, 14 October 2015
DataStage Scenario #7 - Count data in each column
Atul Singh
October 14, 2015
Count the total rows and cells which is having some data in it. Input: col1 col2 col3 a {NULL} b ...
Wednesday, 7 October 2015
Shell Script Scenario #2 - Solution
Atul Singh
October 07, 2015
You can find other scenarios HERE ================================================================================== ==============...
Wednesday, 30 September 2015
Shell Script Scenario #5 - Letters order
Atul Singh
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 ...
