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 are the various kinds of the hash file?
in oracle target stage when we use load option and when we use upsert option?
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 is the difference between informatica and datastage?
What is the purpose of interprocessor stage in server jobs?
What is the difference between orabulk and bcp stages?
Define Merge?
Difference between sequential file and data set?
What is a datastage job?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How will you move hashed file from one location to another location?
What is oci?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
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 types of containers?