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
- 9459 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 |
How you can fix the truncated data error in datastage?
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
Define ds designer?
Give example for FACTLESS FACT TABLE in real-time scenario.
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
What are the steps required to kill the job in Datastage?
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 Answers Scope International,
Is the value of staging variable stored temporarily or permanently?
How to lode data in sequntional files perform faster?
What is job control?
Define project in datastage?
What are system variables and sequencers in datastage
Teradata 
