What are the different database update actions available?
- 1 Answers
- 9373 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Where do the datastage jobs get stored?
What all the types of jobs you developed?
How to perform incremental load in datastage?
Can you explain repository tables in datastage?
What is the different type of jobs in datastage?
What is active and passive stage?
How many areas for files does datastage have?
Can you implement SCD2 using join, transformer and funnel stage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Differentiate between odbc and drs stage?
How a routine is called in datastage job?
Define oconv () and iconv () functions in datastage?
in oracle target stage when we use load option and when we use upsert option?
Is possible to create skid in dim,fact tables?
