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


Please Help Members By Posting Answers For Below Questions

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?

555


What is meant by lookup transformation?

615


What do you understand by a term domain?

670


Explain direct and indirect flat file loading (source file type) - informatica

837


What are the restrictions of union transformation?

581






How do you remove duplicate records in informatica? And how many ways are there to do it?

715


What is primary and backup node?

702


What is the different lookup cache(s)?

614


How do you load alternate records into different tables through mapping flow?

1298


How many numbers of sessions can one group in batches?

623


How to generate or load values in to the target table based on a column value using informatica etl tool.

613


What is the advantage of informatica?

650


Difference between Data and Index Caches?

660


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)

1087


What are roles and groups and benefits of using them?

569