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 is the sortmerge collector?
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
How to display errors in datastage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
What is PX?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
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?
What are the different layers in the information server architecture?
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
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
can we half project in parallel jobs and half project in server jobs?