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
- 11786 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 |
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
How identifying bottlenecks in various components of informatica and resolving them?
State the differences between sql override and lookup override?
how can we perform incremental aggregation?explain with example?
In Which scenario did u used Incremental loading?
How to eliminate duplicate records in informatica mapping? Explain with an example....
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
what is mystery dimension?
What is workflow monitor?
What are session parameters ? How do you set them?
Teradata 
