All Stories

Practical FOR Loop Examples for Your UNIX Shell Script

We have studied basics of looping concepts in shell script here http://www.databaseetl.com/basics-unix-shell-scripting-part-2/. Here we will see some practical examples of very often ...

Basics of UNIX SHELL Scripting : Part-2

Continued from http://www.databaseetl.com/learn-unix-shell-scripting-with-below-simple-steps-part1/ Loops in Shell Script A loop structure is a programming mechanism for repeating ...

Basics of UNIX SHELL Scripting : Part-1

Whenever any newcomer or beginner wants to learn any new programming language like learning unix shell scripting, questions comes to mind is from where do I start? What concepts I need ...

How to Read Multiple Flat Files Using a Single Datastage Job

Generally we use Sequential File stage to read any flat file by setting properties File name, file pattern, delimiter etc. We can read multiple files by setting “Read Method” property ...

SCD and its implementation in Datasage

Datawarehouse is a large storage of data derived from a multiple or different sources and this stored data is used to guide or make management decisions for a particular company. Now ...

SAS ODBC connection

In this article we will see SAS-Oracle integration or “how to access any Oracle database from SAS?”. Here is our main purpose is to create below libname statement to access oracle ...

Partitioning in Datastage

Hey, hope you are doing well. Now in this article we will try to learn different Partitioning and collecting techniques which is one of the essential parts in parallel processing with ...

‘CUT’ command in unix with example

Hi Guys, Hope you all are doing well. We are back with another command in Unix which is very much needed in day to day’s work and our day cannot be completed without using it once ...

sed command in Unix with example

In this article we will be studying one of the most powerful commands in Unix i.e. ‘sed’ which stands for ‘stream editor’. Whenever you want to modify any text, any ...

USER VARIABLE Stage in Datastage

User Variable stage is mainly get used to define/declare Global Variable within a Sequence Variables defined in this stage can used anywhere in the sequence with below syntax UV_Stage_Name.Variable_Name
© 2017 Database ETL. All rights reserved.