1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
1 6729Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
TCS,
1 4366A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
TCS,
3 10184I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
IBM,
3 9367SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?
TCS,
1 6683What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
1 6456hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
5 9887Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
7 11475my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
10 17462how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
3 23906
Differentiate between operational datastage (ods) and data warehouse?
What is the project in datastage?
what is ds administrator used for?
What steps should be taken to improve Datastage jobs?
describe the Steps to confiure a Qlogic switch
What all are the different way to run a job?
What are routines in datastage? Enlist various types of routines.
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?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is apt_config in datastage?
what is the use of skid in reporting?
Differentiate between validated and Compiled in the Datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Define orabulk and bcp stages?
What is a ds designer?