Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different database update actions available?
- 1 Answers
- 10114 Views
- HP, I also Faced
- E-Mail Answers
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 |
How to RD using transformer?
How and where you used hash file?
Where do you see different stages in the designer?
which dim, fact tables used in bank domain
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
What is the default execution order of the sequential file?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
what is the use of materialized view?
What is the difference between datastage and informatica?
what is the diff b/w switch and filter stage in datastage
What is difference between 8.1 , 8.5 and 9.1 ?
Notification Activity
Teradata 
