Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between the join and look up
explin me one exmple
- 3 Answers
- 6029 Views
- I also Faced
- E-Mail Answers
Answer Posted / shar
join lookup
i/p names- left,right,intermediate primary,secondary
join ops - left,right,inner,fullout left,inner
in & out - n i/p(s)-left,right,inner n i/p(s) normal
2 i/p(s)-full outer 2 i/p(s) sparse
1 o/p 1 o/p
rejects - n/a one
sort data- Mandatory optional
KcolNames- Mandatory optional
deduplica- no problem warnings in secondary.
memory - light high
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What could be a data source system?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Define Merge?
What are the primary usages of datastage tool?
Is the value of staging variable stored temporarily or permanently?
What is the process of killing a job in datastage?
What are the functionalities of link partitioner and link collector?
Have you used Unstructured data?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How a server job can be converted to a parallel job?
Define Routines and their types?
What are the steps needed to create a simple basic datastage job?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the types of views in datastage director?
