TO read the xls file in Sequential file, convert xls ta. CSV format
open emp. Xls Save as other format Select CSV (comma delimited) emp .CSV 
Properties file = emp .csv columns load while import select file type .CSVimport ok Tara data with ODBC
Minimize it Control panel Administrative Tools serviceClick on Tara data data base Initiator start close itDefault values User id = td user Password = td user Server = 127.0.0.1 Creating DSN for Tara data Start Control panel Administrative Tools Data base (ODBC)System DSN Add Tara data finish Name = chaladi2, IP address = 127.0.0.1 user name = td user name password = td user Ok DSN created chaladil ODBC Enterprise — Data set Properties Read Method = Table, Data source = chaladil, User = td user, Password =td user Columns load Table Definition importPlug in Meta Data definition click on Tara data okTara data director = 127.0.0.1,User name = td user, Password = td userNextData base = financialSelect only Table Next Select table customer import Table Definition plug in Tara data customer ok ok Now, go to properties 
Now, view Data Dynamic RDMS This is the only stage that supports n inputs and n outputs Oracle can read multiple tables using join but not independently. Using Dynamic RDBMS , we can read multiple tables independently. Properties click on DBMS Type Select oracle connection name (oracle) user (scott) Password (tiger) click on output name = emp columns click on columnsLoad change Data to time stamp click on output name = DeptClick on columns load change data to times stamp
It is a processing stage which has 1 input and n outputs It is the Heart of Data stage. It is an All – in –one stage(Can perform the process of column generator, copy operator) Difference between Basic Transformation and Parallel Transformer: Basic Transformation
Parallel Transformation
C++,VC++,VB,>net Shall Script, pearl Script
Calculating Net Salary by Adding 
Properties Read Method = table Table = EMP
Data set
Browse the fileGive a file name with .ds extension
Add a new column Net Sa Integer 5 click on ok
Double click Right click Select input Column Select Sal in. SalRight click , Select ‘+’ in.sal + Right function Null Handling
Right click Input column Select Can Sal + Null to zero (in. COMM)OkNow Compile and runThese core tutorials will help you to learn the fundamentals of Tableau. For an in-depth understanding and practical experience, explore Online DataStage Training.
Stage Variable:- (Temporary Variable) Stage variable is a temporary variable which he it’s the value until the process complete,But does send the value to the output. If Net Sa > 2000 then Re home = Net Sa – 200 Else Take home = Net Sal +200 Transformer At the bottom. Out, Now create an New column name ‘Take home’ Column Name SQL Type length Take home Integer 8
Double click write the logic here in . Sal + Null Zero (in.Comn) Now go to out Drag the stage variable to out at Net Sal 
Double click Right click If then else if Right click Stage variables If Net Val > 2000 Then Net Val – 2000 else Net Val + 200 okCompile and RUN
SID, S Name, M1, M2, M3, M4 Stage variables
| In. M1 + in. M2 + in. M3 + in .M4 | tot |
| Tot/5 | Avg |
| If Avg >= 60, then “Pass” else “fail” | res |
| If res = “pass” then “A” else “B” | gra |
If tot > 401 and tot < 500 then “A” else if Tot > 302 and tot < 400 then “B” else “c”
For indepth understanding of DataStage click on
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
