What are the different database update actions available?
Answer / fahmida
In server jobs three types of Updates are available,
Update Existing Rows Onlly
Update Existing Rows Or Insert New rows
Insert New rows or Update Existing Rows
In Parallel jobs two types of Update actions are available,
Update
Upsert
| Is This Answer Correct ? | 5 Yes | 1 No |
What all are the different way to run a job?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
i have flat file and using unix how can i generate sequence number into targer?
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
How many types of views are there in a datastage director?
What is the difference between Link collector and Funnel Stages?
How can one find bugs in job sequence?
Main Function of the Staging area in DWH ?