what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?
Answers were Sorted based on User's Feedback
Answer / avinash
Expression tranformation is used in data cleansing.
If ur target table consist of not null column and source
table consisting null columns so assign some value in
expression tr.
and then pass data to target.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shashiall
Source Qualifier Transformation and Expression
Transformation are used for Data cleansing.
Data types ,Date formats,null ..not null
constraints ..these r main things considered in the data
cleansing.
Is This Answer Correct ? | 1 Yes | 0 No |
Hi Friends,
My point of view FILTER AND EXPRESSION TRANSFORMATIONS are
used to data cleansing.
Is This Answer Correct ? | 0 Yes | 0 No |
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
what are the different types of transformation available in informatica and what are the mostly used ?
What is the sequence generator transformation in informatica?
Using Expression transformation how to remove duplicate records from a relational source?
How to create the source and target database connections in server manager?
Plz..let me know differences between Informatica 7.1 and 8.1?
What is domain in terms of informatica?
what is procedure to use mapping variable in source qualifier transformation? with example
How many mapplets u have created? and what is the logic used
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?