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
- 5872 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
How to clean the datastage repository?
What is staging variable?
Explain connectivity between datastage with datasources?
How to read multiple files using a single datastage job if files have the same metadata?
What steps should be taken to improve Datastage jobs?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
State the difference between an operational datastage and a data warehouse?
How one source columns or rows to be loaded in to two different tables?
Describe stream connector?
Is possible to create skid in dim,fact tables?
What are system variables and sequencers in datastage
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are stage variables and constants?
how to add a new records into source?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
