CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN
SERVER JOBS?
Answers were Sorted based on User's Feedback
Answer / nish
Yes,
For jobs that are less resource intensive create a server job.
Create the parallel job as usual
Create a sequencer to combine both jobs or configure a shared container in one of the jobs and re -use them
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kiran
Yes you can, as long as your client is OK with it. We
design jobs to finish certain tasks in ETL. If your task
has less data and more complex tranformations then use
server jobs and vice versa.
| Is This Answer Correct ? | 4 Yes | 4 No |
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..........?
What is staging variable?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
Please tell me What is difference between 8.0 and 8.1
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
how do u catch bad rows from OCI stage? And what CLI stands for?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
how to do pergformence tuning in datastage?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
In merge stage can we update the values?
i have flat file and using unix how can i generate sequence number into targer?