lonerusher
New User
Joined: 30 Nov 2010 Posts: 4 Location: India
|
|
|
|
1. Driver File primary key(means first file primary in Job Input) should always have unique records if you are using key in Job input. If your driver file do not have unique records you need to declare the Job Input as Null and need to handle the file balancing logic using the DO WHILE logic.
2. Secondary File in Job Input : In secondary file its optional that you will always have unique records means it can have duplicate records for the primary key. Now if you want those duplicate elements in your output file just simply use job input and use if matched logic.
If you don't want duplicates into your output file, then you need to handle that using Job input NULL and do while. Alternatively you can do that using flag logic like storing the primary key into some temp variable and always comparing the new value and last value and then putting your logic.
3. If you are not sure about your input files always use JOB INPUT file as NULL and handle the files using DO while logic.
Enjoy ! hope this helps you in future.. |
|