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 / itsranjan
In properties window of sequence generator one can select
reset or cycle option to avoid such kind of situations.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the tasks that source qualifier perform?
How do you load unique records into one target table and duplicate records into a different target table?
Differentiate between reusable transformation and mapplet.
Where are the source flat files kept before running the session?
What is a dimensional model?
What is blocking transformation?
In how many ways we can create ports?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What if the source is a flat-file?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How are the sources and targets definitions imported in informatica designer?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?