how many write modes are there in ds
Answers were Sorted based on User's Feedback
Answer / sudhir kanojia
There are five types of write modes:-
1.Append
2.Overwrite
3.Create(Error if exist)
4.Use existing (discard record)
5.Use existing (discard record & schema)
Posted By:-
Sudhir Kanojia
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / saidarao
APPEND
CREATE
TRUNCATE
REPLACE
ONLY 4 WRITE MODES IN DATASTAGE
Is This Answer Correct ? | 3 Yes | 0 No |
How do you design PX Routines ?
What is the purpose of interprocessor stage in server jobs?
how to design the change capture stage in(data stage parallel jobs) type 2
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
how can u find out the datastage job is running on how many nodes
Which commands are used to import and export the datastage jobs?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
difference between function and procedure...
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?