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)

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers  

What is the difference between Link collector and Funnel Stages?

1 Answers  

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

what is the main difference between sorragate key n primary key in one word

2 Answers  

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

Differentiate between datastage and informatica?

0 Answers