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
- 9700 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
options available in sequence job to run,validate?
Demonstrate experience in maintaining quality process standards?
What is the flow of loading data into fact & dimensional tables?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How to RD using transformer?
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
Whats difference betweeen operational data stage (ods) and data warehouse?
What is "fatal error/rdbms code 3996" error?
What are the some differences between 7.x and 8.x version of datastage?
How and where you used hash file?
What are some prerequisites for datastage?
What is a datastage job?
State the difference between an operational datastage and a data warehouse?
What is the purpose of pivot stage?
