Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different database update actions available?
- 1 Answers
- 10132 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
What are some prerequisites for datastage?
Define ds designer?
What are the various kinds of the hash file?
Give an idea of system variables.
What is the different type of jobs in datastage?
Is it possible to query a hash file?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
how to delete one row in target dataset
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How to read multiple files using a single datastage job if files have the same metadata?
What are the different type of jobs in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is staging variable?
State the difference between an operational datastage and a data warehouse?
