Rishi

• Dec 5th, 2005

 

Yes, we can use Informatica for cleansing data. some time we use stages to cleansing the data. It depends upon performance again else we can use expression to cleasing data.

For example an feild X have some values and other with Null values and assigned to target feild where target feild is notnull column, inside an expression we can assign space or some constant value to avoid session failure.

The input data is in one format and target is in another format, we can change the format in expression.

we can assign some default values to the target to represent complete set of data in the target.

prasadns26

 Profile Answers by prasadns26 

• Jul 18th, 2006

 

hi,

what ever said by rishi is correct,

info can be used as a cleansing tool.

usually EXP is used for cleaning data using data cleansing functions and other functions present in infa.

eg,

assign default values for a not null fields.

remove spaces if any in flat file sources by usning LTRIM and RTRIM.

if date has some char in between then remove that char by using REPLACECHAR.

u can use SUBSTR to remove extra char.

there are many more functions and uses to be explored.