How can we achive parallelism
Answer / hanug
The degree of parallelism is achieved by configuring the
multiple nodes in the congig file.
In the config files we can specify multiple nodes.
| Is This Answer Correct ? | 14 Yes | 1 No |
How you Implemented SCD Type 1 & Type 2 in your project?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me
What is the default padding character?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
wt is the difference between swith and filter stage
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
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?
What is the flow of loading data into fact & dimensional tables?
Name the command line functions to import and export the DS jobs?