How to import oracle sequence into Informatica. - CREATE ONE PROCEDURE AND DECLARE THE SEQUENCE INSIDE THE PROCEDURE,FINALLY CALL THE PROCEDURE IN INFORMATICA WITH THE HELP OF STORED PROCEDURE TRANSFORMATION. - Informatica Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

INFORMATICA

DETAILS

Question: How to import oracle sequence into Informatica.

Answer: CREATE ONE PROCEDURE AND DECLARE THE SEQUENCE INSIDE THE PROCEDURE,FINALLY CALL THE PROCEDURE IN INFORMATICA WITH THE HELP OF STORED PROCEDURE TRANSFORMATION.

Category	Informatica Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9143 users
Added on	7/26/2011
Views	73275
Rate it!

Question: How to import oracle sequence into Informatica.

Answer:

CREATE ONE PROCEDURE AND DECLARE THE SEQUENCE INSIDE THE PROCEDURE,FINALLY CALL THE PROCEDURE IN INFORMATICA WITH THE HELP OF STORED PROCEDURE TRANSFORMATION. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Could anyone please tell me what are the steps required for type2 dimension/version data mapping. how can we implement it	View Answer
	With out using Updatestretagy and sessons options, how we can do the update our target table?	View Answer
	Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?	View Answer
	what is the best way to show metadata(number of rows at source, target and each transformation level, error related data) in a report format	View Answer
	If u had to split the source level key going into two seperate tables. One as surrogate and other as primary. Since informatica does not gurantee keys are loaded properly(order!) into those tables. What are the different ways you could handle this type of situation?	View Answer
	How to append the records in flat file(Informatica) ? Where as in Datastage we have the options i) overwrite the existing file ii) Append existing file	View Answer
	What are partition points?	View Answer
	What are cost based and rule based approaches and the difference	View Answer
	What is mystery dimention?	View Answer
	What is difference b/w Informatica 7.1 and Abinitio	View Answer
	What is Micro Strategy? Why is it used for? Can any one explain in detail about it?	View Answer
	Can i start and stop single session in concurent bstch?	View Answer
	I want to prepare a questionnaire. The details about it are as follows: - 1. Identify a large company/organization that is a prime candidate for DWH project. (For example Telecommunication, an insurance company, banks, may be the prime candidate for this) 2. Give at least four reasons for the selecting the organization. 3. Prepare a questionnaire consisting of at least 15 non-trivial questions to collect requirements/information about the organization. This information is required to build data warehouse. Can you please tell me what should be those 15 questions to ask from a company, say a telecom company?	View Answer
	what is difference between lookup cashe and unchashed lookup? Can i run the mapping with out starting the informatica server?	View Answer
	What is the difference between stop and abort	View Answer
	Can we run a group of sessions without using workflow manager	View Answer
	If a session fails after loading of 10,000 records in to the target.How can u load the records from 10001 th record when u run the session next time in informatica 6.1?	View Answer
	I have an requirement where in the columns names in a table (Table A) should appear in rows of target table (Table B) i.e. converting columns to rows. Is it possible through Informatica? If so, how?	View Answer
	What is meant by complex mapping	View Answer
	Explain use of update strategy transformation	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Informatica Interview Questions & Answers - Exam Mode / Learning Mode