Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9625 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 is the purpose of interprocessor stage in server jobs?
What is the method of removing duplicates, without the remove duplicate stage?
Difference between server jobs & parallel jobs?
How to perform incremental load in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Explain connectivity between datastage with datasources?
What are the difference types of stages?
What is ds designer?
how to delete one row in target dataset
Describe stream connector?
Difference between data warehousing and olap?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the areas of application?
How to convert RGB Value to Hexadecimal values in datastage?
Define data aggregation?
