In seqence generator transformation maximum limit is
reached,after reaching maximum limit how will u insert the
data
- 2 Answers
- 10821 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
Answer Posted / shilpa
When a Seq Gen Transformation reaches its maximum value and
the sequence is not configured to cycle, the session fails.
Either you need to cycle the sequence or increase the end
value.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain pushdown optimization $pushdownconfig parameter - informatica
What is meant by query override?
How do you load only null records into target?
How many ways are there to do 'remove duplicate records in informatica'?
What is persistent lookup cache?
Clarify the utilization of aggregator cache record?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Does an informatica transformation support only aggregate expressions?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What do mean by local and global repository?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
