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
- 11872 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 |
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
whats the logic to load the lower level of granularity of data to fact table.
what is the monster dimension plz give me one example
what is the use of Java Transformation in Informatica 8.x?
How to load the data from people soft hrm to people soft erm using informatica?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
can u any challenge your project?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Which transformation is needed while using the Cobol sources as source definitions?
Teradata 
