when we will use connected Lookup & Unconnected Lookup
- 3 Answers
- 9839 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 |
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How many areas for files does datastage have?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
why dataset ?
What is a range lookup?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is the process of killing a job in datastage?
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
Teradata 
