Interested to Buy Any Domain ? << Click Here >> for more details...
can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
- 2 Answers
- 8367 Views
- I also Faced
- E-Mail Answers
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 |
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
how many maximum session supports to multiload in teradata ??
what is the difference between cardinality and Nullability?
dimension object created in oracle can be imported in designer?how?
Difference between flat files and relational sources?
What is a lookup table in etl?
how would u estimate the size of Aggregator transform data and index cache?
What is tracing level?
what do u do when DB time takes more?in sap bi
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.
how would u estimate the size of Lookup transform data and index cache?
How many types of transformations supported by sorted input?
Teradata 
