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
- 33593 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 could be a data source system?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Name the different sorting methods in datastage.
What are the processing stages?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Triggers,VIEW,Procedures
How to perform incremental load in datastage?
What is data partitioning?
EXPLAIN SCD
Lookup constraints
What are the various kinds of the hash file?
I have a few records just I want to store data in to targets cycling way how?
how to add a new records into source?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the difference between datastage and datastage tx?
