Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Hi I am Vijay
In my source i've 10 records in a single column.... but i
want to split those records into 5 sequential files each
seq file contains 2 records.?.... can any body help me?

Answer Posted / p.ganesh

HAI THIS IS GANESH

IF SF CONTAINS 10 RECORDS USING SURRAGATE ID
GERNERATOR,TRANSFORMER STAGAE WE CAN SPLIT THE DATA INTO
MULTIPLE TARGERS

SF--SURRAGATE ID GENERATOR--TRANSFORMER--TGT1
--TGT2
--TGT3
--TGT4
--TGT5
IN SURRAGATE ID GENERATOR WE CAN GENERATE THE SID VALUES,NEXT
IN TRANSFORMER STAGE WE CAN CLINK ON CONSTRAINT THEN APPLY
THE EXPRESSION AS
IF MOD(DLLINK.SID,5)=1 THEN 1 ELSE 0,THIS IS FOR TGT1
IF MOD(DSLINK.SID,5)=2 THEN 1 ELSE 0,THIS IS FOR TGT2
IF MOD(DSLINK.SID,5)=3 THEN 1 ELSE 0 ,THIS IS FOR TGT3
IF MOD(DSLIND.SID,5)=4 THEN 1 ELSE 0,THIS IS FOR TGT4
IF MOD(DSLINK.SID,5)=0 THEN 1 ELSE 0,THIS IS FOR TGT5


HERE MOD(DSLINK,SID,NO.OF OUTPUT)=CONDITION
THEN
1,6 TO TGT1
2,7 TO TGT2
3,8 TO TGT3
4,9 TO TGT4
5,10 TO TGT5
IF U HAVE ANY DOUBT PLS CONTACT ME
MOBILE:9538631567

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1398


How rejected rows are managed in datastage?

1496


What is a ds designer?

1058


how do u catch bad rows from OCI stage? And what CLI stands for?

2789


Why do we use exception activity in Datastage?

1288


How do you start developing a datastage project?

1089


What is the difference between informatica and datastage?

1203


What is the command line function to import and export the ds jobs?

1134


Difference between in process and inter process?

1211


what is the custome stage in datastage? how can we impliment that one? plz tell me

2348


What can we do with datastage director?

1223


Can you explain players in datastage?

1178


Nls stands for what in datastage?

1182


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2366


If you want to use the same piece of code in different jobs, how will you achieve it?

1134