Interested to Buy Any Domain ? << Click Here >> for more details...
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
- 3 Answers
- 7525 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / datastage4you
You can try to put a copy stage with force=True propertly. It can inhance the performance
http://goo.gl/atN4AT
www.datagenx.net
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a merge?
options available in sequence job to run,validate?
How will you move hashed file from one location to another location?
How many Key we can define in remove duplicate stage?
Define orabulk and bcp stages?
What is the difference between passive stage and active stage?
On which Dimension Table you implemented SCD Type in your Project
Define data aggregation?
What is the difference between an operational datastage and a data warehouse?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
I have a few records just I want to store data in to targets cycling way how?
What is datastage?
What is the sortmerge collector?
How rejected rows are managed in datastage?
