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 |
What are the types of Data Warehouse applications?
what is dynamic insert?
how to load the data to fact table?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
What are various etl tools in the market?
Give the benefits of data integration suite?
what are the facilities provided by data warehouse to analytical users?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
what are the different forms of normalization?
In Which Transformation We Can Use Having Clause In Informatica?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
Explain the use lookup tables and Aggregate tables?