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
What are the types of containers?
What is a merge in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Difference between sequential file and data set?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Is possible to create skid in dim,fact tables?
Difference between data warehousing and olap?
Describe link sort?
What are stage variables and constants?
I have a few records just I want to store data in to targets cycling way how?
What is use Array size in datastage
Where do you see different stages in the designer?
What is staging variable?
How many Key we can define in remove duplicate stage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?