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 |
How a source file is populated?
Differentiate between operational datastage (ods) and data warehouse?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
Hi Vijay here For Four CPU's how many nodes will required?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
What are the important features of datastage?
what is usage of datastage with materialized views
What are the different database update actions available?
how many dimentions and fact tables used in your project and what are names of it?