how can u generate sequence of values in which target has
more than 2billion of records.(but with sequence generator
u can generate upto 2 biliion only)
Answer Posted / sridhar tirukovela
By using the variable port in the Expression transformation
we can create more than 2 billion records.
Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
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?
What is meant by lookup transformation?
What do you understand by a term domain?
Explain direct and indirect flat file loading (source file type) - informatica
What are the restrictions of union transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is primary and backup node?
What is the different lookup cache(s)?
How do you load alternate records into different tables through mapping flow?
How many numbers of sessions can one group in batches?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the advantage of informatica?
Difference between Data and Index Caches?
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 are roles and groups and benefits of using them?