What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer?
Latest Answer: The basic transformer stage is similar in appearance and function to the Normal Transformer Stage. Basic transformer stage can only be used for SMP(Symmetric Multiprocessors) systems and not for MPP(Massively Parellel Processing) system or clusters ...
when the data processed by job1 is locked by job2 with higher priority, what will happen about the status of job1, changing from running to aborted , or still running. does it have any relationship with
Latest Answer: If its reference dataset and you are doing Lookup then job will run but no records will come from that Dataset, so you should rerun the dataset job and then run the other job to get the records. ...
Latest Answer: deyault buffer size foe seq file is 128MB. if you want increse manually, to to Adminstrator tunable tab--> buffer size option there you can specify if you want increase.regards,Veeru. ...
Why and where and how is MQ series stage used in datastage?
What are the differences between Sparse Lookup and Normal Lookup?
Latest Answer: normal look-up:all the reference table data is stored in the buffer for cross- check with the primary table data.sparse lookup:each record of the primary table is cross checked with the reference table datethe types of look-ups will araise only if the ...
How to implement Slowly changing dimesions Type2 in Parallel jobs . What are the stages we use and How to assign the key?
Latest Answer: Datastage Px 8.0.1 is having SCD stage to perform the required operation. Or it can be achived by using lookup/change capture stage in between source and target database. ...
Explain What is mean by Hashing Algorithm?
Latest Answer: Hashing alogarithm is used when you create hash files in server jobs. it takes key field and distribute records avilable cpus in DS sercver while running the DS job. the cpu utiliztion in this process may vary based on server configuration.Regards,Veeru. ...
How to remove duplicates in datastage?
Latest Answer: There are several ways in removing the duplicates depends on the data u have..have to use stage variables effectively to remove the duplicates.use rowprevious compare function.. which is available in datastage...RegardsSriks ...
What is the difference between jobcontrol and sequencer?
Latest Answer: Jobcontrol: It just inserts the compilation code. Whenever you add the job it just places executable code there. There is no
diagrammatical representation here.Sequencer: Sequencer is a
diagrammatical representation where we can connect different ...
when do one use dataset stage/lookup file stage/file stage in a parallel job?or in other way what is the significance of these files...wat are their differences?
Latest Answer: DataSetFile: DataStage PX jobs uses the dataset file to organize the data.Dataset files preserves partitioning means u need not to partition the data when ever u read the data.It maintaines the persistent form.These are the operating system files.we can't ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
