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 / mukesh
write logic of seq gen. in a procedure and Use store proc
transformation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
On which transformations you created partitions in your project?
What is informatica etl tool?
What is a passive transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the difference between stop and abort in informatica
What are the differences between source qualifier and joiner transformation?
What are the different clients of powercenter?
What are connected or unconnected transformations?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Can we override a native sql query within informatica?
How many ways are there to create ports?
What do you mean by channel change?
can u any challenge your project?
Explain lookup transformation is active in informatica