Interested to Buy Any Domain ? << Click Here >> for more details...
when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 11472 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
Describe stream connector?
Triggers,VIEW,Procedures
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
what is use of SDR function?
I have a few records just I want to store data in to targets cycling way how?
what is the use of skid in reporting?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is the purpose of pivot stage?
How will you move hashed file from one location to another location?
What are stage variables and constants?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Explain the importance of surrogate key in data warehousing?
What is the importance of the exception activity in datastage?
Differentiate between data file and descriptor file?
