how to load summary and detail records in single target file
Posted: Sat Oct 08, 2005 11:10 pm
Hello All,
I want to know how to load summary record and detail records in a single target file.
number columns in summary and detail records will be different
A1 abc 20051009 (summary record)
B abc 20051009 123 456 678 (detail record)
B abc 20051009 234 532 567 (detail record)
B abc 20051009 654 234 234 (detail record)
A1 cde 20051009 (summary record)
B cde 20051009 123 456 678 (detail record)
B cde 20051009 234 532 567 (detail record)
B cde 20051009 654 234 234 (detail record)
based on column need to load summary and detail records in a single target file.
Please suggest me how to implement this logic.
Thanks in advance
Arvind
I want to know how to load summary record and detail records in a single target file.
number columns in summary and detail records will be different
A1 abc 20051009 (summary record)
B abc 20051009 123 456 678 (detail record)
B abc 20051009 234 532 567 (detail record)
B abc 20051009 654 234 234 (detail record)
A1 cde 20051009 (summary record)
B cde 20051009 123 456 678 (detail record)
B cde 20051009 234 532 567 (detail record)
B cde 20051009 654 234 234 (detail record)
based on column need to load summary and detail records in a single target file.
Please suggest me how to implement this logic.
Thanks in advance
Arvind