1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

I am having the 2 source files A and B and I want to get the
output as, the data which is in file A and which doesn't in
file B to a target 1 and which is in file B and which doesn't
in file A to a target 2?

Question Posted / hemanth.datastage

Answers were Sorted based on User's Feedback



I am having the 2 source files A and B and I want to get the output as, the data which is in file ..

Answer / chandra swain(hara)

mapping for above job

fileA---->joinstage---->transformer------->dataset1
^ ------>dataset2
|
|
fileB


go to joinstage ,take type of join is fullouter join,

then copy the i/p column to o/p link ,goto transformer stage
u 'll found 2 constraint tab ,in 1st constraint tab write
leftRec_column<>rightRec_column And LeftRec_column<>0,

similarly in 2nd constraint tab write
leftRec_column<>rightRec_column And RIGHTRec_column<>0

then copy only LeftRec_column to dataset1
and copy only RightRec_column to dataset2


i think u definitly get the correct answer

Is This Answer Correct ?    9 Yes 1 No

I am having the 2 source files A and B and I want to get the output as, the data which is in file ..

Answer / reddymkl.dwh

FullOuter
FileA------->Join--------->Filter-------->T1
| |
| |
| |
| |
FileB T2
Use Fullouter Join Then
Filter-------> Where =Right.link=''
Where =Left.link=''
Nothing but A-B, B-A scenario.

Plz correct me if am wrong.....

Is This Answer Correct ?    0 Yes 0 No

I am having the 2 source files A and B and I want to get the output as, the data which is in file ..

Answer / upputuri.vinod

I am going to explain with example.

A B T1 T2
1 1 2 7
2 7-----> Now according to the QA in 3 9
3 9 4 5.
4 5


i am going to use the lookup stage..


1-------LK2<----B
! !
! !
T2 A---->LK1------1

T1


here T1 is the rejected data from LK1 where T2 rejected data
from LK2.

The condition in LK is Reject.

I hope U got the point..

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Data Stage Interview Questions

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

4 Answers   TCS,

Describe the main features of datastage?

0 Answers  

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

How do you remove duplicate values in datastage?

0 Answers  

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,




source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

which memory is used by lookup and join

5 Answers   IBM,

how to define satge variables in transformer stage

2 Answers  

What are the types of containers and how to create them?

0 Answers  

What modeling tool do you use?

6 Answers   HP,

For more Data Stage Interview Questions Click Here
Categories