If you know Better Answer, Comment Below!

Monday, March 2, 2015

Define Routines and their types?

No comments:

Routines are basically collection of functions that is defined by Datastage manager. It can be called through  transformer stage. There are 3 types of routines such as
a)  parallel routines
b) main frame routines
c)server routines.
Read More

How does Copy Stage works in Processing

No comments:

Having single input in the source wants the repetition of the input in the column of the target using only stage.

Read More

Sunday, March 1, 2015

Differentiate between Massive Parallel Processing and Symmetric Multiprocessing ?

No comments:

in Massive Parallel processing, the processor access the hardware resources exclusively. This type of processing is also known as Shared Nothing, since nothing is shared in this. It is faster than the Symmetric Multiprocessing.
While in In Symmetric Multiprocessing, the hardware resources are shared by processor. The processor has one operating system and it communicates through the shared memory.

Read More

Differentiate between data file and descriptor file?

No comments:
Please find Below for the Answer.

As the name implies, data files contains the data and the descriptor file contains the description/information about the data in the data files.

If you know better Answer Comment Below. 
Read More

Friday, February 27, 2015

Some methods to Unlock Datastage job from Unix Command line

No comments:

1.telnet to DS server machine as ds administrative account (dsadm or root for example);
2. cd to $DSHOME - to go to DSEngine;
3. source dsenv by “. ./dsenv”; (read as dot_space_dot_dsenv)
4. run “bin/uvsh” to enter TCL prompt
5. run “>LIST.READU EVERY”, are you able to find any lock for the project under Active Record Locks? If yes, mark down the Userno for the command below;
6 run “>UNLOCK USER userno ALL”;
7. run “>LIST.READU EVERY” again to verify the lock for the user is gone;
8. repeat step 6 and 7 until all locks for the project is clear;
9. run “>LO” to exit TCL prompt.'
Read More

Sunday, January 25, 2015

What steps should be taken to improve Datastage jobs?

No comments:
In order to improve performance of the Datastage jobs.
a)We have to first establish the baselines.
2)We should not use only one flow for performance testing.
 3)We should work in increment.
Then, we should evaluate data skews. Then we should isolate and solve the problems, one by one. After that, we should distribute the file systems to remove bottlenecks, if any. Also, we should not include RDBMS in start of testing phase. Last but not the least, we should understand and assess the available tuning knobs.
Read More

Tuesday, January 20, 2015

Source is a flat file and has 200 records . These have to split across 4 outputs equally . 50 records in each .

No comments:
The total number of records in the source may vary everyday ,according to the count records are to split equally at 4 outputs.

Keep four files as output.Simply give modulus(col_name,4)=0 constraint for first file ,modulus(col_name,4)=1 second file and modulus(col_name,4)=2 for third file and finally modulus(col_name,4)=3

You can write your Opinion below in the Comment  to help Others
Read More

Popular Posts