Interested to Buy Any Domain ? << Click Here >> for more details...
when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 11346 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
This Questions Related for Informatica not in Datastage.
| Is This Answer Correct ? | 10 Yes | 0 No |
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 |
Can you explain players in datastage?
What is a datastage job?
How to Convert the columns into rows?
Define oconv () and iconv () functions in datastage?
how can we extract data with out having any common column
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
When we will go for Data elements?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
What is difference between symmetric multiprocessing and massive parallel processing?
To see hidden files in LINIX?
What is the difference between datastage and datastage tx?
Teradata 
