what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?
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
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What do you mean by worklet?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the function of union transformation?
What is the sequence generator transformation in informatica?
How do you load only null records into target? Explain through mapping flow.
Why filter transformation is an active one?
Why do you use Mapping Parameter and mapping variable?
What are the prerequisite tasks to achieve the session partition?
What is union transformation in informatica?
What is a filter transformation?
How would you join a node to the already existing domain?
Explain the different lookup methods used in informatica?
What is informatica etl tool?
Differentiate between router and filter transformation?