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

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,

DataStage Scenario based Interview Questions

1 Answers  

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

How a source file is populated?

0 Answers  

How many types of sorting methods are available in datastage?

0 Answers  

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

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  

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

What is the importance of the exception activity in datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories