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
Our Services

INTERVIEW QUESTIONS DATA WAREHOUSING DETAILS
Question :

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

Category Data Warehousing Interview Questions
Rating (3.1) By 27 users
Added on 8/26/2014
Views 255
Rate it!


Answers:

Source: CoolInterview.com

f 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



Source: CoolInterview.com

One reason can be in Connected lookup for non matching columns it returns default value for output port to target, whereas in unconnected lookup for non-matching columns we get NULL as output.
Source: CoolInterview.com



Posted by: Amit

Contact Amit Contact Amit

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.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification Enter the above shown code: *
Inform me about updated answers to this question

Related Questions
View Answer
What are the types of External Loader available with Informatica?
View Answer
How many ways U can update a relational source definition and what r they?
View Answer
What is the approximate size of a data warehouse?
View Answer
What is a data mart?
View Answer
What are the benefits of data warehousing?
View Answer
What is OLTP?
View Answer
What are dimensions?
View Answer
What are fact tables?
View Answer
What are measures?
View Answer
What are aggregations?
View Answer
What are cubes?
View Answer
Explain in brief about critical column.
View Answer
What is data cleaning? How can we do that?
View Answer
Why is SAS so popular?
View Answer
What is XMLA?
View Answer
What is Virtual Data Warehousing?
View Answer
What is a level of Granularity of a fact table?
View Answer
Explain time series algorithm in data mining?
View Answer
What are non-additive facts in detail?
View Answer
What is snapshot?
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 Data Warehousing Interview Questions & Answers



User Options
India News Network

Latest 20 Questions
Is eCommerce Entry Tax a double duty of taxation or any reduction is provided in Gujarat?
What is the Rate at which the eCommerce Entry Tax to be charged in Gujarat?
Does once filed/paid return-cum-challan can be revised?
When is the tax collected to be deposited with Gujarat VAT Department in Gujarat?
How is the tax collected to be deposited with Gujarat VAT Department in Gujarat?
Which Goods are liable for the Entry Tax in Gujarat?
Why Facilitators are made liable for the Payment of Entry Tax in Gujarat?
Who has to pay the Entry Tax in Gujarat?
What will happen to the Entry Tax in Gujarat, if the buyer is from Gujarat however the Goods are to be delivered to Person outside Gujarat?
When the liability to pay eCommerce entry tax in Gujarat does arise?
What is the intention or reason for expanding the tax net to online transactions?
Is ECommerce Entry Tax something totally new introduced in Gujarat?
What is the Name of the Act under which Online Transactions become liable for Entry Tax in Gujarat?
What is the Ecommerce Entry Tax applicable in Madhya Pradesh?
What is the Ecommerce Entry Tax applicable in Himachal Pradesh?
What is the Ecommerce Entry Tax applicable in Sikkim and West Bengal?
What is the Ecommerce Entry Tax applicable in Maharashtra?
What is the Ecommerce Entry Tax applicable in Jammu and Kashmir?
What is the Ecommerce Entry Tax applicable in Uttarakhand?
No waybill is required for import of printing materials under rule 99 of the W.B.V.A.T. Rules, 2005. Will entry tax have to be paid on its import?



Fresher Jobs | Experienced Jobs | Government Jobs | Walkin Jobs | Company Profiles | Interview Questions | Placement Papers | Companies In India | Consultants In India | Colleges In India | Exams In India | Latest Results | Notifications In India | Call Centers In India | Training Institutes In India | Job Communities In India | Courses In India | Jobs by Keyskills | Jobs by Functional Areas

Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes

Gate Articles | Gate Books | Gate Colleges | Gate Downloads | Gate Faqs | Gate Jobs | Gate News | Gate Sample Papers | Gate Training Institutes

MBA Articles | MBA Books | MBA Case Studies | MBA Business Schools | MBA Current Affairs | MBA Downloads | MBA Events | MBA Notifications | MBA FAQs | MBA Jobs
MBA Job Consultants | MBA News | MBA Results | MBA Courses | MBA Sample Papers | MBA Interview Questions | MBA Training Institutes

GRE Articles | GRE Books | GRE Colleges | GRE Downloads | GRE Events | GRE FAQs | GRE News | GRE Training Institutes | GRE Sample Papers

IAS Articles | IAS Books | IAS Current Affairs | IAS Downloads | IAS Events | IAS FAQs | IAS News | IAS Notifications | IAS UPSC Jobs | IAS Previous Question Papers
IAS Results | IAS Sample Papers | IAS Interview Questions | IAS Training Institutes | IAS Toppers Interview

SAP Articles | SAP Books | SAP Certifications | SAP Companies | SAP Study Materials | SAP Events | SAP FAQs | SAP Jobs | SAP Job Consultants
SAP Links | SAP News | SAP Sample Papers | SAP Interview Questions | SAP Training Institutes |




Copyright ©2003-2016 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions



Cache = 0.007812 Seconds