Interested to Buy Any Domain ? << Click Here >> for more details...
when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 11175 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 |
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
What are the types of views in datastage director?
what is diff b/w datastage 8.1,8.5,8.7?
What are constraints and derivations?
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
Give example for FACTLESS FACT TABLE in real-time scenario.
How to lode data in sequntional files perform faster?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
Can you highlight the main features of ibm infosphere information server?
Differentiate between validated and Compiled in the Datastage?
what is main difference between change capture and change apply stages
Is there any possibility to generate alphanumeric surrogate key?
Teradata 
