How can you define a transformation? What are different
types of transformations in Informatica?
Answer Posted / rahul
a transformation basically is a mechanism which enables
transforming the data as per the business requirement.
for eg in the source database if the date is in the mm dd
yyyy format and in the target database the date is in dd mm
yyyy format,so we apply transformation to remove the
inconsistancy
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to know the time taken for particular report execution?
How to join 3 database like flat file, oracle, db2 in informatrica?
What is surrogate key? Explain with examples.
Explain er diagram?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What is the main difference between inmon and kimball philosophies of data warehousing?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What are the methodologies of data warehousing?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is the difference between connected and unconnected stored procedures?
What is data mart in data warehouse?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is the limit to the number of sources and targets you can have in a mapping?
Explain what are the steps to build the data warehouse?
What is the difference between view materialized view and view?