DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Md Dawar Mughni
Participant



Joined: 30 Sep 2009
Posts: 10
Location: Pune,India
Points: 98

Post Posted: Sun Jan 09, 2011 6:24 pm Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Hi All,

The requirement is to split the file into multiple files based on
1.Each file should contain specific number of records or less then that
and
2.All the key columns should be in single file

Eg:
source file :

col1 col2
1 a
1 b
1 c
2 d
3 k
3 g
4 b
5 x
5 b


if number of records in each o/p file should be <= 4
then outpu files would be

file1:

col1 col2
1 a
1 b
1 c
2 d

file2:

col1 col2
3 k
3 g
4 b

file3:
col1 col2
5 x
5 b

How to impliment it in Datastage?

Appreciate the help in advance.

Warm Regards,
-Dawar
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54431
Location: Sydney, Australia
Points: 295208

Post Posted: Sun Jan 09, 2011 7:54 pm Reply with quote    Back to top    

Welcome aboard.

This particular forum is for the Transformation Extender, not for DataStage. You should have posted your question in the Enterprise Edition forum.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Not yet rated
manoj_23sakthi
Participant



Joined: 23 Feb 2010
Posts: 47
Location: CHENNAI
Points: 248

Post Posted: Mon Jan 10, 2011 4:16 am Reply with quote    Back to top    

Hi,
By Using Filter,Transformer stages you can achive this

Regards,
Manoj
Rate this response:  
Not yet rated
manoj_23sakthi
Participant



Joined: 23 Feb 2010
Posts: 47
Location: CHENNAI
Points: 248

Post Posted: Mon Jan 10, 2011 4:17 am Reply with quote    Back to top    

Hi,
By Using Filter,Transformer stages you can achive this

Regards,
Manoj
Rate this response:  
Not yet rated
Md Dawar Mughni
Participant



Joined: 30 Sep 2009
Posts: 10
Location: Pune,India
Points: 98

Post Posted: Mon Jan 10, 2011 4:27 am Reply with quote    Back to top    

Thnaks Ray.
This is my first post so made the mistake.

I have raise it in Enterprise Edition forum.

Please answer.

Regards
Dawar
Rate this response:  
Not yet rated
Md Dawar Mughni
Participant



Joined: 30 Sep 2009
Posts: 10
Location: Pune,India
Points: 98

Post Posted: Mon Jan 10, 2011 11:57 am Reply with quote    Back to top    

Thanks for the answer,
Could you please explain the logic.
Thnaks
-Dawar

manoj_23sakthi wrote:
Hi,
By Using Filter,Transformer stages you can achive this

Regards,
Manoj
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours