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
- 7985 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chethankumar
take 2sequential files 1 funnel 1 filter 3 targets
1)load the files to sequential files
2)join both the records using funnel
3)in filter go to input tab perform sort enable stable
and in where clause give condition if col<6 one target
col>5 and col<11 second, third col>10
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / mohit
We can solve this by using Change capture stage. First,we
use source as 'A' and refrerence as 'B' both of them are
connected to Change capture stage. From, change capture
stage it connected to filter stage and then targets X,Y and
Z.
(Change Code '0'--->exist in both, copy record
Change Code '1'--->Exists in SRC 'A', INSERT record
Change Code '2'--->Exists in SRC 'B', DELETE record
Change Code '3'--->Exists in 'A' & 'B' with changes, UPDATE
record)
In the filter stage:
Change_code column=1 it goes to 'X' [1,2,3,4,5]
Change_code column=0 it goes to 'Y' [6,7,8,9,10]
Change_code column=2 it goes to 'Z' [11,12,13,14,15]
| Is This Answer Correct ? | 2 Yes | 0 No |
You are right chetan, but in the second lookup we have to
use seq file 1 for main link and o/p2 is linked as reference.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / radhika m
Add an extra column 'colA' and 'colB' to the files 'A' and 'B' respectively. Let the value for colsA be 'a' for all the rows in file 'A' and the value for colB be 'b' in file 'B'(using the column generator stage).Now join both the files using join stage using 'ID' column. Perform full outer join. Map the ID col, colA and colB to output. Next pass it through a transformer.
Transformer constraint:
1) file X - colA=a and colB<>b ----->[1,2,3,4,5]
2) file Y - colA=a and colB=b------->[6,7,8,9,10]
3) file Z - colA<>a and colB=b------>[11,12,13,14,15]
Drop cola and colB in the output.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chaint
seqfile 1 --> Lookup on seq file 2 --> output2 -->
|
|
reject link(output1)
output 2--> lookup on seq file 2
|
reject link (output3)
| Is This Answer Correct ? | 0 Yes | 1 No |
explain about citrix scheduling tool in datastage
What is the use of hoursfromtime() function in transformer stage in datastage?
Name the different types of Lookups in Datastage?
Define Job control?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
What is oci?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
Can you highlight the main features of ibm infosphere information server?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
What are the benefits of datastage?
What is lookup table?
What is apt_config in datastage?
Teradata 
