Interested to Buy Any Domain ? << Click Here >> for more details...
table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
- 9 Answers
- 15095 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramachandra rao.pinninty
In both tables having any common key column use join
stage,other wise in both the tables any columns having same
data type and data length use lookup otherwise that means
there is no common key column,and data length,types are not
same using surrogate key or column generator in both the
tables use join stage.in target it dispaly's 10 fields.
NOTE:the question was little bit clumbsy(there is no clarity)
so these are the way's to solve the senario.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Explain the importance of surrogate key in data warehousing?
How to reverse the string using SQL?
how to implement scd2 in datastage 7.5 with lookup stage
what is the use of materialized view?
What are the important features of datastage?
What are the different layers in the information server architecture?
What are constraints and derivations?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the components of datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
what is repositery?
What are the functionalities of link partitioner?
Can we use target hash file as a lookup ?
