Which is better among connected lookup and unconnected lookup transformations in informatica or any - If you are having defined source you can use connected, source is not well defined or from different database you can go for unconnected We are using like that only - 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: Which is better among connected lookup and unconnected lookup transformations in informatica or any other ETL tool?

Answer: If you are having defined source you can use connected, source is not well defined or from different database you can go for unconnected

We are using like that only

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

Question: Which is better among connected lookup and unconnected lookup transformations in informatica or any other ETL tool?

Answer:

If you are having defined source you can use connected, source is not well defined or from different database you can go for unconnected

We are using like that only

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
	In Dimensional modeling fact table is normalized or denormalized?in case of star schema and incase of snow flake schema?	View Answer
	What is difference between IIF and DECODE function	View Answer
	What are variable ports and list two situations when they can be used?	View Answer
	How does the server recognise the source and target databases?	View Answer
	How to retrive the records from a rejected file. explane with syntax or example	View Answer
	How to lookup the data on multiple tabels.	View Answer
	What is the procedure to load the fact table.Give in detail?	View Answer
	What is the use of incremental aggregation? Explain me in brief with an example.	View Answer
	How to delete duplicate rows in flat files source is any option in informatica	View Answer
	How to use mapping parameters and what is their use	View Answer
	in the concept of mapping parameters and variables, the variable value will be saved to the repository after the completion of the session and the next time when u run the session, the server takes the saved variable value in the repository and starts assigning the next value of the saved value. for example i ran a session and in the end it stored a value of 50 to the repository.next time when i run the session, it should start with the value of 70. not with the value of 51. how to do this.	View Answer
	can any one comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i. I mean how is oracle 9i advantageous when compared to oracle 8 or 8i when used in informatica	View Answer
	Can we use aggregator/active transformation after update strategy transformation	View Answer
	Why dimenstion tables are denormalized in nature ?	View Answer
	In a sequential Batch how can we stop single session?	View Answer
	How do you handle decimal places while importing a flatfile into informatica?	View Answer
	How do you handle decimal places while importing a flatfile into informatica?	View Answer
	If you are workflow is running slow in informatica. Where do you start trouble shooting and what are the steps you follow?	View Answer
	If you have four lookup tables in the workflow. How do you troubleshoot to improve performance?	View Answer
	Can anyone explain error handling in informatica with examples so that it will be easy to explain the same in the interview.	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