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...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

when we will use connected Lookup & Unconnected Lookup

Question Posted / narsi

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

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  

what is a nodemap constraint

2 Answers   IBM,

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

What are the processing stages?

0 Answers  

What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

Can you highlight the main features of ibm infosphere information server?

0 Answers  

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

What are the benefits of datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories