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
How can we handle two sessions in informatica?
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?
Under which circumstances, informatica server creates reject files?
What is union transformation?
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?
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 is decode in informatica?
design of staging area?
How to load a Dimension ? and how to load a fact table?
Explain the use of aggregator cache file?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How can we delete duplicate rows from flat files?
Have you worked with/created Parameter file
What is the reusable transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.