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
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
Difference between in process and inter process?
To see hidden files in LINIX?
I have a few records just I want to store data in to targets cycling way how?
sed,awk,head
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are stage variables?
What is the differentiate between data file and descriptor file?
Can you explain kafka connector?
What are constraints and derivations?
What is a ds designer?
What are stage variables and constants?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Describe the architecture of datastage?
Have you used Unstructured data?
What is size of a transaction and an array means in a datastage?