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?
- 15 Answers
- 32892 Views
- Scope International, I also Faced
- E-Mail Answers
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
What all are the different way to run a job?
What is the flow of loading data into fact & dimensional tables?
What is job control?
Can you explain players in datastage?
How to reverse the string using unix?
Define Routines and their types?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is size of a transaction and an array means in a datastage?
What steps should be taken to improve Datastage jobs?
Can you explain engine tier in information server?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the difference between in process and inter process?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
how to write server Routine coding?
What is the difference between Datastage 7.5 and 7.0?
