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 |
What is the difference between Active and Passive transformation?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
what is the size of ur database(like oracle)
What are the types of data that passes between informatica server and stored procedure?
How to load relational source into file target?
Can you access a repository created in previous version of Informatica?
How big was your fact table
how to load only the first and last record of a flat file into the target?
What are the differences between a connected lookup and unconnected lookup?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa