table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answer Posted / akhi
It is Simple in join stage fullouterjoin technique we get
all 10 coloumns
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is the use of hoursfromtime() function in transformer stage in datastage?
Explain how a source file is populated?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How do u convert the columns to rows in datastage?
Where the datastage stored his repository?
What is the difference between operational data stage (ods) and data warehouse?
What is a quality stage in datastage tool?
how to export or import the jobs in .ISX file
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How to read the length of word in unix?
What all are the different way to run a job?
What are the difference types of stages?
Name the different types of Lookups in Datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?