Порция юморка

и так бывает

Порция юморка

Как обстоят дела на моем проекте. У нас все хорошо

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

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

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}

Which of SELECT, UPDATE, DELETE, performance is mostly affected by indexes?

I have found answer on this blog:

The number of indexes on a table is the most dominant factor for insert
performance. The more indexes a table has, the slower the execution becomes. The insert statement is the only operation that cannot directly benefit from indexing because it has no where clause.