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

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.....

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..

Define Data Stage?

0 Answers  

---

how to add a new records into source?

0 Answers  

---

How do you get log info into a file?

1 Answers  

---

Highlight the main features of datastage?

0 Answers  

---

what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers   TCS,

---

---

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

---

SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  

---

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  

---

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

---

what is set mapping in datastage??

2 Answers   ADP,

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,

---

Name the third party tools that can be used in datastage?

0 Answers  

---