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

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]

Answer / vinod upputuri

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.

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=''

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.

Answer / chaint

seqfile 1 --> Lookup on seq file 2 --> output2 -->
|
|
reject link(output1)


output 2--> lookup on seq file 2
|

reject link (output3)

How one source columns or rows to be loaded in to two different tables?

0 Answers  

WHAT are unix quentios in datastage

2 Answers   TCS,

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

Difference between sequential file and data set?

0 Answers  

How to clean the datastage repository?

0 Answers  

how do you pass parameters in a script?

1 Answers   L&T,

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,