can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
Answers were Sorted based on User's Feedback
Answer / maruthi
ys we can clean data by using informatica upto a extent,by
using expression transformation by using below varaibles
1.)ltrim,rtrim,ifnull,isnull,such so many fn u can get in
transformation
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / birendra
Yes we can clean data by using informatica through
expression transformation
Is This Answer Correct ? | 0 Yes | 0 No |
How to delete data which is not in source table?
0 Answers IBM, Saama Tech, Wipro,
Define Dynamic push down optmization?
what do u do when DB time takes more?in sap bi
Define slowly changing dimensions (SCD)?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
what is data modeling?
what is meant by drill through?(Mascot)
Difference between flat files and relational sources?
Give the benefits of data integration suite?
What are various etl tools in the market?
Can u access a repository created in previous version of Informatica?
Explain different types of partitioning?