Answer Posted / usha
Data cleansing means removing unwanted spaces.
By using LTRim,Rtrim functions we can remove unwanted space
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Is possible to create skid in dim,fact tables?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the steps needed to create a simple basic datastage job?
Triggers,VIEW,Procedures
What is the purpose of interprocessor stage in server jobs?
What are the important features of datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Can you highlight the main features of ibm infosphere information server?
What is the project in datastage?
What are the components of datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How you can fix the truncated data error in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
how to run a sequential file stage in parallel if the stage is used on the TARGET side