it is possible to load two tables data into one sequential
file?if possible how?plz share with me?
Answer Posted / srikanth reddy m
If the two tables having same key column, then based on that key column we can able join the two tables. This is nothing but horizantal joining.
or
If the the two tables having same metadata, then using funnel stage we can perform vertical joining. whether it may continuous or sequence funnel.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the process of killing a job in datastage?
Can you define merge?
Difference between server jobs & parallel jobs?
What are some different alternative commands associated with "dsjob"?
What are the functionalities of link collector?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Can you explain how could anyone drop the index before loading the data in target in datastage?
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?
What are the benefits of datastage?
What are the different layers in the information server architecture?
Which algorithm you used for your hashfile?
Define Data Stage?
What are the processing stages?
how to add a new records into source?