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 |
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
SCD2 will work on only dimension tables as well as fact Table?
What do you understand by active and passive transformations?
what are Lookup caches options? Including persistent caches.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
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 is pmrep command?
what is session partitioning?
what is the use of server?
Explain and compare etl & manual development?