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
- 8241 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
where are the log files generally stored.Can you change the path of the file.what can the path be?
What are the various tools used in etl?
what do u do when DB time takes more?in sap bi
Difference between flat files and relational sources?
What are the three tiers in etl?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what is the difference between cubes and package in cognos
What are cubes and olap cubes?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
what are the concerns of OLTP and DSS systems?
How etl testing is different from database testing?
