merge the two files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Sun Aug 19, 2007 11:44 pm
merge the two files
Hi
I hava a two seq files
file1
ENO,ENAME
101,ABC
102,BBB
103,DDD
FILE2
SAL,AGE
50000,45
7000,66
8000,77
Using this data i want to merge the file, i don"t have a key colum.
Thanks
I hava a two seq files
file1
ENO,ENAME
101,ABC
102,BBB
103,DDD
FILE2
SAL,AGE
50000,45
7000,66
8000,77
Using this data i want to merge the file, i don"t have a key colum.
Thanks
ramakrishna
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: merge the two files
[quote="murari83.ds"]Hi
I hava a two seq files
file1
ENO,ENAME
101,ABC
102,BBB
103,DDD
FILE2
SAL,AGE
50000,45
7000,66
8000,77
I sove this problem using this
seqfile1----->surrogatekey---
merge---->seqfile
seqfile2--> surrogate key------
my problem is
i want to target out like this, any posibility
out put
ENO ENAME SAL AGE
101 ABC 8000 77
102 BBB 7000 66
103 DDD 50000 45
thanks
I hava a two seq files
file1
ENO,ENAME
101,ABC
102,BBB
103,DDD
FILE2
SAL,AGE
50000,45
7000,66
8000,77
I sove this problem using this
seqfile1----->surrogatekey---
merge---->seqfile
seqfile2--> surrogate key------
my problem is
i want to target out like this, any posibility
out put
ENO ENAME SAL AGE
101 ABC 8000 77
102 BBB 7000 66
103 DDD 50000 45
thanks
m.ramakrishna
Re: merge the two files
'any possibility' = cartesian product/join?murari83 wrote:murari83.ds wrote:Hi
I hava a two seq files
file1
ENO,ENAME
101,ABC
102,BBB
103,DDD
FILE2
SAL,AGE
50000,45
7000,66
8000,77
I sove this problem using this
seqfile1----->surrogatekey---
merge---->seqfile
seqfile2--> surrogate key------
my problem is
i want to target out like this, any posibility
out put
ENO ENAME SAL AGE
101 ABC 8000 77
102 BBB 7000 66
103 DDD 50000 45
thanks
-
- Participant
- Posts: 12
- Joined: Sun Sep 23, 2007 12:21 am
- Location: chennai
Use Two SUrrogate key generator one after each sequential file stage, then use a merge stage and in the merge stage output mapping remove the key that is generated using surrogate key generator. note tat while using surrogate key generator use same name as key for both surrogate key generators.
dineshm
Re: merge the two files
Hi
i want to target out like this, any posibility
out put
ENO ENAME SAL AGE
101 ABC 8000 77
102 BBB 7000 66
103 DDD 50000 45
thanks
i want to target out like this, any posibility
out put
ENO ENAME SAL AGE
101 ABC 8000 77
102 BBB 7000 66
103 DDD 50000 45
thanks
m.ramakrishna
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
What are your rules for joining the data?
From your example we could infer you are intending to join Ascending ENO on descending SAL - Right?
J.
From your example we could infer you are intending to join Ascending ENO on descending SAL - Right?
J.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Re: merge the two files
yes,
ENO ascending and SAL Decending,meand
first eno records to Sal last record
thanks
ENO ascending and SAL Decending,meand
first eno records to Sal last record
thanks
m.ramakrishna
-
- Participant
- Posts: 24
- Joined: Wed Oct 17, 2007 1:28 am
- Location: hyderabad
Re: merge the two files
murari83.ds wrote:Hi
I hava a two seq files
file1
ENO,ENAME
101,ABC
102,BBB
103,DDD
FILE2
SAL,AGE
50000,45
7000,66
8000,77
Using this data i want to merge the file, i don"t have a key colum.
Thanks
TRY TO USE FUNNEL STAGE
ETL=DS
-
- Participant
- Posts: 24
- Joined: Wed Oct 17, 2007 1:28 am
- Location: hyderabad
Re: merge the two files
sanath1234 wrote:murari83.ds wrote:Hi
I hava a two seq files
file1
ENO,ENAME
101,ABC
102,BBB
103,DDD
FILE2
SAL,AGE
50000,45
7000,66
8000,77
Using this data i want to merge the file, i don"t have a key colum.
Thanks
TRY TO USE FUNNEL STAGE//quote]
ETL=DS
Re: merge the two files
Hi,
Sort file1 using ENO and file2 using SAL.Using column generator create a Key column for both these file and then join these.Simply remove the key column in the next stage.
Sort file1 using ENO and file2 using SAL.Using column generator create a Key column for both these file and then join these.Simply remove the key column in the next stage.
Vikas Jawa