how does work server jobs?
Answer / archana
When we have lots of functionality to implement for lower volume and hardware is less and ease of implementation we can go for Server jobs.
We can improve the performance of server job by enabling inter process row buffering. This helps stages to exchange data as soon as it is available in the link. IPC stage also helps passive stage to read data from another as soon as data is available.
The choice of server or parallel depends upon time to implement, functionality and cost.
Server jobs do not run on multiple node.
server job runs on windows platform usually
server job runs on one node
Server jobs process in sequence one stage after other
Server jobs doesn't support partition parallelism
server jobs the transformer is compiled in Basic language.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain how a source file is populated?
How to read multiple files using a single datastage job if files have the same metadata?
What are the unit test cases you used in your project?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
when we will use connected Lookup & Unconnected Lookup
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
How many types of views are there in a datastage director?
can we use sequential file as a lookup
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
why we use parameters instead of hard code in datastage