I have 2 Files like
fileA fileB Output1 Output2 Output3
1 6 1 6 11
2 7 2 7 12
3 8 3 8 13
4 9 4 9 14
5 10 5 10 15
6 11
7 12
8 13
9 14
10 15
please let know
- 6 Answers
- 8411 Views
- I also Faced
- E-Mail Answers
Answer Posted / kanakam
hi guys for this scenario we need to do the following steps
1.First take the two sequential file stages
2.Use the Join stage,in join stage use the fullouter join
3.Take the Filter stage in filter stage we have to write
the where clause conditions:
a.for getting the Output1:Right.columnname=''
b.For gettting the output2:Right.columnname=left.columnname
c.for getting output3:Left.columnname=''
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the some differences between 7.x and 8.x version of datastage?
What is the differentiate between data file and descriptor file?
What are the partitioning techniques available in link partitioner?
What is the difference between an operational datastage and a data warehouse?
Notification Activity
What is the difference between the local container and shared container?
Where the datastage stored his repository?
Explain how a source file is populated?
What are datastage sequences?
table actions available in oracle connector?
Name the command line functions to import and export the DS jobs?
What is data partitioning?
Give an idea of system variables.
How to implement complex jobs in data stage?
how to sort two columns in single job in datastage.
