in which situations do u go for sequence generator ?
Answer Posted / mahesh
In the Fallowing Situations we use Sequence Generator
Transformation
1)Creating Primary Key Values
2)Replacing The Missing Key Values
3)When You Apply the Cycle Through a Sequential Range Of
Numbers
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How would you copy the content of one repository to another repository?
What is an aggregator transformation?
How do you load only null records into target? Explain through mapping flow.
Explain the use of aggregator cache file?
What is the difference between informatica 7.0 and 8.0?
What do you mean by enterprise data warehousing?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How do you load first and last records into target table?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is a joiner transformation and why it is an active one?
How can we use mapping variables in informatica? Where do we use them?
In informatics server which files are created during the session rums?
How do you load unique records into one target table and duplicate records into a different target table?
Enlist some properties of sessions.
What is pmcmd command?