what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?
- 3 Answers
- 11126 Views
- I also Faced
- E-Mail Answers
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 persistant cache in which situation we will use persistantcache
What are mapping parametres and variables in informatica?
whats the logic to load the lower level of granularity of data to fact table.
What is the function of aggregator transformation?
how i will stop my workflow after 10 errors
What is the difference between IN and Exists in Oracle?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
how do u move the code from development to production?
What is session task and command task?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
Teradata 
