Interested to Buy Any Domain ? << Click Here >> for more details...
when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 11337 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How many types of hash files are there?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What steps should be taken to improve Datastage jobs?
How do you import and export data into datastage?
What are the types of jobs we have in datastage?
Differentiate between operational datastage (ods) and data warehouse?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is the difference between operational data stage (ods) and data warehouse?
Define Routines and their types?
Describe routines in datastage? Enlist various types of routines.
What is use Array size in datastage
Why do we use exception activity in Datastage?
What is ds designer?
What is the difference between passive stage and active stage?
