Interested to Buy Any Domain ? << Click Here >> for more details...
what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?
- 3 Answers
- 11881 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 |
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
what is the complex transformation you used in informatica
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
How can we create index after completion of load process?
if i have a delimited file as source so how can we seperate this file into three diff targets?
What is transformation?
What is the sql query overwrite in source qualifier in informatica
what is diffrence b/w joner and union transfermation
How to handle changing source file counts in a mapping?
What does command task mean?
if soource is having 10 records how will u insert 20 records to target
What are variable ports and list two situations when they can be used?
Teradata 
