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
- 8259 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what happens if the info.server doesn't find the session parameter in the parameter file?
Give the benefits of data integration suite?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how many steps are there in etl process?
What is etl process?
What is etl process? How many steps etl contains?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What is a materialized view log?
Explain different types of partitioning?
Explain about hash partitioning?
dimension object created in oracle can be imported in designer?how?
Which transformation we use to convert 'NA' to 'Not Available'
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?
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 project backlog and product backlog?
