when we will use connected Lookup & Unconnected Lookup
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 |
How can we improve the performance in datastage?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
what is combinability and non combinability?
What are the prerequisites for join stage
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
client know skid info?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
how to create document in datastage?
what is datastage job Monitoring
Name the different sorting methods in datastage.
What are the functionalities of link collector?