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


Please Help Members By Posting Answers For Below Questions

Where do we use semi and non additive facts?

592


Explain functional dependency?

621


What is difference between query studio and report studio?

532


How to provide security in frame work manager for a query subject?

524


Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

543






How to test report in reportnet?

570


How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

560


What are algorithms provided by Microsoft in SQL Server?

1576


What is the difference between mapping parameter & mapping variable in data warehousing?

559


Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

516


What is a hash cluster?

525


Explain what is the difference between view filter and report filter?

577


What is core dimension?

555


what are the others of "bad files" and "discard files" when using sql*loader?

1632


Explain a mapping, session, worklet, workflow, mapplet?

603