how do u use sequence created in oracle in informatica?
Explain with an simple example

Answer Posted / sujay

by writing sql override in the source qualifier by calling
sequence which you have created in oracle

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are 3 tech challenges/ common issues you face?

1865


can u any challenge your project?

1579


How many types of sessions are there in informatica.please explain them?

650


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1661


Does an informatica transformation support only aggregate expressions?

576






How can we use mapping variables in informatica?

572


Can we get 1st record through Informatica(without sequence number).

938


What is a connected transformation?

652


How might you approve all mappings in the archive all the while?

574


Partition, what happens if the specified key range is shorter and longer

2006


What is joiner transformation?

562


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1891


explan ur project architecture?

1571


Target increases every day even though no new record was inserted

1078


What is a grid in Informatica?

591