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
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the purpose of pivot stage?
What is the precedence of stage variables,derivations, and constraints?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How to convert RGB Value to Hexadecimal values in datastage?
What are the types of containers?
What is the purpose of pivot stage and types of containers in datastage
What are orabulk and bcp stages?
How to perform incremental load in datastage?
What is the differentiate between data file and descriptor file?
Explain the situation where you have applied SCD in your project?
Which commands are used to import and export the datastage jobs?
Define meta stage?
How do you remove duplicate values in datastage?