Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


when we will use connected Lookup & Unconnected Lookup

Answers were Sorted based on User's Feedback



when we will use connected Lookup & Unconnected Lookup..

Answer / kiran

This Questions Related for Informatica not in Datastage.

Is This Answer Correct ?    10 Yes 0 No

when we will use connected Lookup & Unconnected Lookup..

Answer / kalyanreddy

This question is belongs to informatica...

Is This Answer Correct ?    5 Yes 0 No

when we will use connected Lookup & Unconnected Lookup..

Answer / jayanthi

In Datastage, the same can be expalained as Normal
(Connected)Lookup and Sparse(unconnected) lookup.

For sparse lookup
When the refrence data volume is huge and primary volume is
very less,you can pass the input records key columns to
match against reference in refrence table extraction query
where clause.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Data Stage Interview Questions

How can we improve the performance in datastage?

0 Answers  


in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,


what is combinability and non combinability?

2 Answers  


What are the prerequisites for join stage

2 Answers  


How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,


client know skid info?

0 Answers   NTT Data,


How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,


what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers   TCS,


how to create document in datastage?

1 Answers   Cap Gemini,


what is datastage job Monitoring

6 Answers   CTS,


Name the different sorting methods in datastage.

0 Answers  


What are the functionalities of link collector?

0 Answers  


Categories