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
- 15419 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
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is a datastage job?
Nls stands for what in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
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?
options available in sequence job to run,validate?
Name the different sorting methods in datastage.
How you Implemented SCD Type 1 & Type 2 in your project?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Where the datastage stored his repository?
What are the different layers in the information server architecture?
Define Merge?
I have a few records just I want to store data in to targets cycling way how?
How complex jobs are implemented in datstage to improve performance?
Differentiate between Join, Merge and Lookup stage?
