Interested to Buy Any Domain ? << Click Here >> for more details...
i have seq file that contents 10 million records load to target any data base..
in that case it takes lot of time for loading..how do performance tuning in that situation...?
- 5 Answers
- 14269 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
1) In sequential stage we have stage properties on that
select options and increase the readers
2) In datastage admin we have on environmental variable like
logical reader that set as one
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is the use of datastage designer?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are stage variables, derivations and constants?
What is the difference between passive stage and active stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the steps needed to create a simple basic datastage job?
how to export or import the jobs in .ISX file
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How to convert RGB Value to Hexadecimal values in datastage?
What are transforms and what is the differenece between routines and transforms?
How to RD using transformer?
What all the types of jobs you developed?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is process model?
