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 |
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
Hi All can anyone tell me where i will get Informatica training in Mumbai?
how will compare two mappings in two different repository?
What is an unconnected transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How to update a particular record in target with out running whole workflow?
What is partioning?how many types of partinings are there
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
how you will maintain version?
Why we need XMLs?
What is aggregate awareness?