Seq1,Seq2--->join--->removeduplicate---->filter--->trg1,trg2,tr

file1
1
2
3
4
file2
3
4
5
6

output should be in three targets
T1 T2 T3
1 3 5
2 4 6

how to do this? can any one help?

Thanks

Question Posted / prabhu rathnam

5 Answers
13524 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / prabhu rathnam

Seq1,Seq2--->join--->removeduplicate---->filter--->trg1,trg2,trg3

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3606

in oracle target stage when we use load option and when we use upsert option?

2200

Difference between in process and inter process?

1162

Notification Activity

1345

How to read the length of word in unix?

1310

root tree will find which is server job and which is parallel job?

1880

What could be a data source system?

939

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

725

project Steps,hits, Project level HArd things,Solved methods?

2063

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3412

How do you import and export the datastage jobs?

1109

What is the difference between datastage and datastage tx?

1006

What is meta stage?

1128

How many types of sorting methods are available in datastage?

1020

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1470