in sequtial file 2 columns avaliable,iwant only one column
load the target how do it.
Answer Posted / babloo
inspite of all you can use the copy stage and simply map
the required column to the output.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is "fatal error/rdbms code 3996" error?
how can we create rank using datastage?what is the meaning of rank?
I have a few records just I want to store data in to targets cycling way how?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are the primary usages of datastage tool?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is the sortmerge collector?
Can you filter data in hashed file?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Define repository tables in datastage?
What is the importance of the exception activity in datastage?
What is the roundrobin collector?
Define orabulk and bcp stages?