What is the differentiate between data file and descriptor file?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
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?
why dataset ?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
What is data partitioning?
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
What is the difference between an operational datastage and a data warehouse?
Sequential 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?
What is usage analysis in datastage?
Define oconv () and iconv () functions in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?