Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different database update actions available?
- 1 Answers
- 10219 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 |
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
data stores in which location while using data set stage as the target?
What are the various kinds of the hash file?
Tell me the syntax of Configuration file?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
1)How to Duplicate Records Delete in Sequential file?
How to read multiple files using a single datastage job if files have the same metadata?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
How can we achive parallelism
Teradata 
