what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?
- 3 Answers
- 11150 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define mapplet?
What are the performance considerations when working with aggregator transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How to do unit testing in informatica? How to load data in informatica ?
Under what condition selecting sorted input in aggregator may fail the session?
How many input parameters can exist in an unconnected lookup?
What is DR strategy for Informatica project?
what is song in infrmatica...?
What are the types of schemas we have in data warehouse and what are the difference between them?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is a filter transformation?
How we can create indexes after completing the loan process?
What is joiner change?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Enlist the advantages of informatica.
