when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 9878 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
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
what is the use of materialized view?
CHANGE CAPTURE
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the different layers in the information server architecture?
Where do you see different stages in the designer?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is datastage engine?
Describe link sort?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are datastage sequences?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is the difference between hashfile and sequential file?
How a server job can be converted to a parallel job?
Why fact table is in normal form?
