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
What are the uses of etl tools?
Explain load alternative records / rows into multiple targets - informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is Session and Batches?
What are the new features of informatica 9.x in developer level?
Design time, run time. If you don't create parameter what will happen
where to store informatica rejected data?
can we override a native sql query within informatica? How do we do it?
what is the size of your data warehousing?
What is deployment group?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the differences between oltp and olap?
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.
How is union transformation utilized?
What does “tail –f” command do and what is its use as an Informatica admin.