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

describe the Steps to confiure a Qlogic switch

0 Answers   IBM,

---

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,

---

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

---

how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,

---

table actions available in oracle connector?

0 Answers   CTS,

---

How a source file is populated?

0 Answers  

---

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

---

How we can covert server job to a parallel job?

0 Answers  

---

what is datastage job Monitoring

6 Answers   CTS,

---

What are the different options associated with dsjob command?

0 Answers  

---

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

---