Answer Posted / sujana
it is generated at runtime..acts as pk in fact table..
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the measure objects?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Name the different lookup cache(s)?
How to improve the performance of a session using sorter transformation?
What is meant by active and passive transformation?
What are the differences between a connected lookup and unconnected lookup?
What are the tuning techniques you applied during your last project
What is an aggregator transformation?
Enlist the advantages of informatica.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Define enterprise data warehousing?
How can informatica be used for an organization?
Design a mapping to load a target table with the following values from the above source?
tell me the rules and responsblites in our project(my project is development)
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?