Answer Posted / jerry
to_date(to_char(Field_Name,'dd-mm-yyyy'),'dd/mm/yyyy');
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
State the difference between an operational datastage and a data warehouse?
What could be a data source system?
What are the components of ascential data stage?
What is "fatal error/rdbms code 3996" error?
What are the functionalities of link partitioner and link collector?
CHANGE CAPTURE
What all the types of jobs you developed?
What are the different kinds of views available in a datastage director?
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.
whom do you report?
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.
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Define Job control?