Selecting Input File

shivakumar · Post by **shivakumar** » Mon Mar 27, 2006 6:51 am

I have to create a parrallel job in that I am taking input from a Flat file.Suppose I am having a Indicator Flag it is having Vaues as 'C' and 'I'.If i get the Flag Value then I have to take the Input From File1 and If I Get the Flag Value as 'N' then I have to take the Input from File 2.

If the Meta data of the Two files are same then How Can Handle this?
If the Meta data of the Two files are different then How Can I handle this?

Without Writing a Script Can I handle this in DataStage Or Else I have to Call a Unix Routine for this , If so then How can I call that Routine.

Thanks and Regards
Siva

roy · Post by **roy** » Mon Mar 27, 2006 7:54 am

Hi and Welcome aboard

,
You can do it in DataStage either way.
You can use parameters and sequence jobs to conditionally execute processing flow.
You can use DS basic language if you need it.
You can use multiple instance jobs if you want to use the same job (in case the Meta data of the Two files is the same) .
All depending on the knowladge you have and the need.

How is the indicator flag supplied?

IHTH,

kumar_s · Post by **kumar_s** » Mon Mar 27, 2006 9:37 pm

Read the file using Execute command activity in the Job Sequence and pass the value of indicated as command output by echo <indicator field>.
Use NestedCondition activity receive the command output as parameter and check for the value. Based on the value divert two output link.
By this you can handle either same layout or different layout.