what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?
Answer Posted / 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 |
Post New Answer View All Answers
What is an unconnected transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
Explain sessions?
How to handle decimal places while importing a flatfile into informatica?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are connected or unconnected transformations?
What differs when we choose the sorted input for aggregator transformation?
What are roles and groups and benefits of using them?
What is intricate mapping?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain lookup transformation source types in informatica
What are the tuning techniques you applied during your last project
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How you prepared reports for OLAP?