Interested to Buy Any Domain ? << Click Here >> for more details...
when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 11354 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 is the difference between validated and compiled in the datastage?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
What are the types of containers in datastage?
What is datastage engine?
how CAN we remove duplicates in dataset?
1.what is materialized data? 2.how to view the materialized data?
How to Remove Duplicate using SQL?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
i want job aborted after some records are loaded into output by using only sequential stage and dataset
how to export or import the jobs in .ISX file
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
Teradata 
