what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?
Answer Posted / d.chandrasekar
Hi Friends,
My point of view FILTER AND EXPRESSION TRANSFORMATIONS are
used to data cleansing.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Explain the code page compatibility?
Explain lookup transformation is active in informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
write a query to retrieve the latest records from the table sorted by version(scd)
What is lookup change?
Enlist the various types of transformations.
What is exclusive and normal mode for repository services?
What is Session and Batches?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the different types of olap? Give an example?
Differentiate between Load Manager and DTM?
Different qualification between a related rotate toward the sky and isolates look upward?