3. Suppose Seq Gen is supplying a increamental value to a column
of a table, suppose, table's column value reaches to maximum
value, then what will happen, will the session fail? If it is the
situation, then what should be done so that we can stop this kind
of situation in advance?
Answer Posted / bebbo
in the properties window of seq. gen you can either select
reset or cycle option to avoid the above situation...
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to generate sequence numbers?
What is the command used to run a batch?
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?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the need for an etl tool?
What are active transformations.
What are the reusable transformations?
What you know about transaction control transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
what is the Default Source Option For Update Strategy Transformation?
How are the sources and targets definitions imported in informatica designer?
How you prepared reports for OLAP?
How can we improve session performance in aggregator transformation?
How to load a Dimension ? and how to load a fact table?
What are the different options available for update strategy?