Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 13008 Views
- Accenture, I also Faced
- E-Mail Answers
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
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is a sequence generator transformation?
What does refresh system mean, and what are its distinctive choice?
How can we use mapping variables in informatica? Where do we use them?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How many types of sessions are there in informatica.please explain them?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is Data Caches size?
How do you load only null records into target?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is an unconnected transformation?
How is union transformation utilized?
What is aggregator transformation in informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
