Немного юморка

Немного юморка

DataStage job that compares rows

1. Create Parallel job that take data from 2 tables

2. Specify columns to compare 

 3. Specify mapping

4. Specify output that has CnageCode

  4. Add Basic transformer that can handle warnings.

Немного юморка

Немного юморка. Настроение на сегодня

DataStage create job that truncate table. Delete Data from table using DataStage job

Now I am working as ETL tester. Our main tool is IBM Datastage, so I will leave small tips to me for future development.

Here I provide steps.

1. Create parallel job 

2. Use Row Generator that generates 1 row for one column  

3. database connector(Oracle in my case)

4. Ctr+ J add parameter Table name

Save and compile job ) 

Have a nice day

Java exersises

Arrays

•  Specify array that has length n. Input n from command line.Fill array using random values.Find minimum value.

•  Specify array that has length 10 and fill randomly.Sort array

• Find number of occurrences of some number in given array of numbers. 

• Find duplicate number in the following array{1,4,5,1,6,7,8,9,11}