In merge stage can we update the values?
Answers were Sorted based on User's Feedback
Answer / kumar
Hi,
How you can Update the values by using merge stage?. It is
for joining and merging purpose only
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sadanand
Merge stage is used for horizontal combining of data from
different tables having common columns.
We cannot update the values using Merge stage.
Correct me if I am wrong.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kiran
you can update values.
But Quetion is not properly.
| Is This Answer Correct ? | 4 Yes | 4 No |
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
How can we do null handling in sequential files
Why we use surrogate key?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
WHAT IS FORCE COMPILE?
Explain the scenarios where sequential file stage runs in parallel?
what is executable in DataStage?
What a datastage macro?
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?