DataStage - what is the meaning of the following..1)If an input file has an excessive number of rows and can be

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 122 of 377

what is the meaning of the following..

1)If an input file has an excessive number of rows and can be split-up then use standard

2)logic to run jobs in parallel

3)Tuning should occur on a job-by-job basis. Use the power of DBMS.

Total Answers and Comments: 2

Last Update: November 08, 2006 Asked by: sudhakar

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

February 28, 2006 03:53:49

Sharanu Patil

RE: what is the meaning of the following..1)If...

Question is not clear eventhough i wil try to answer something

If u have SMP machines u can use IPC,link-colector,link-partitioner for performance tuning

If u have cluster,MPP machines u can use parallel jobs

Is this answer useful? Yes | No

November 08, 2006 04:05:48

tannya

RE: what is the meaning of the following..1)If...

The third point specifies about tuning the performance of job,use the power of DBMS means one can improve the performance of the job by using teh power of Database like Analyzing,creating index,creating partitions one can improve the performance of sqls used in the jobs.

Is this answer useful? Yes | No

Finding Personal Meaning In Your Career

When we talk about personal meaning in terms of our career, people often think it’s about turning your passion or favorite hobby into a job. However, personal meaning can mean different things to different people. Your personal meaning doesn’t necessarily have to come from a job that you

Related Categories

—

DataStage Interview Questions Related

—