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 |
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what is the difference between OLTP database and data warehousing database?
how many maximum session supports to multiload in teradata ??
what is the difference between normal & bulk loading? and which one is recommended ? why?
Explain me ETL project architecture in Detail?
what are the facilities provided by OLAP to analytical users?
Explain what is etl process? How many steps etl contains explain with example?
What are dimensions?
Eliminating of duplicate records without using dynamic lookups
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
Need Informatica Power Center 9.1 free download(for all windows version)
what is the difference between cubes and package in cognos