I am five tab delimited files(same meta data), i want to app

[4friends]

I am five tab delimited files(same meta data), i want to append them in single oracle table.In wat way i can append.

[4friends]

I am having five tab delimited files(same meta data), i want to append them in single oracle table.In wat way i can append.

[sachin1]

job design as below.

take all of your five input input files ----> Transformer--->hash file(or sequential file if you want to maintain duplicate records)-->OCI stage (Insert rows without clearing).

hope this design may help.

2nd design:
may folder stage also help.

[ray.wurlod]

Use a Sequential File stage. Set it to use a Filter command. Use type or copy as the filter command.

Code: Select all

type file1 file2 file3 file4 file5

DataStage reads the output of the filter command.

[gateleys]

Or, use a Link Collector to merge them before loading.

[4friends]

Hey,
In Informatica, by using one single stage we can extract from five files..
In datastage there is an option like that....

I am very new to Datastage guys... thats why.......

[ray.wurlod]

Sure is. Sequential File stage, either with a Filter command as indicated, or with five output links.

Code: Select all

            -------------->
    Seq     -------------->   Oracle
    File    -------------->   OCI
    stage   -------------->   stage
            -------------->

And that's just with server jobs. In parallel jobs there are even more options, for example a single Sequential File stage reading using multiple File property values or a wildcard, using parallel processes.