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?
specify data stage strength?
What is the difference between in process and inter process?
How will you move hashed file from one location to another location?
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
how can u handle null values in transformer stage.
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
how can you generate sequence number using only the sequential file stage?
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?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is the sortmerge collector?