Interested to Buy Any Domain ? << Click Here >> for more details...
it is possible to load two tables data into one sequential
file?if possible how?plz share with me?
- 6 Answers
- 12820 Views
- TCS, I also Faced
- E-Mail Answers
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
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
how can we create rank using datastage?what is the meaning of rank?
What is the difference between operational data stage (ods) and data warehouse?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is process model?
What is the difference between server job and parallel jobs?
How many types of views are there in a datastage director?
What are the different layers in the information server architecture?
What are the different types of lookups in datastage?
What are datastage sequences?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the flow of loading data into fact & dimensional tables?
What are the different plug-ins stages used in your projects?
Can you define merge?
AGGREGATOR default datatype
