IICS | Scenario question (Find odd/even records and write into target)
Scenario Question
To generate odd and even records and write into CSV file.
1. Source - Query used determine odd/even records
2. Transaction control transformation separate records
3. Target - Write into dynamic files.
--Source query used... (oracle db/scott schema used for reference)
select * from (
select
e.*,
mod(rownum,2) as remainder
from emp e)
order by remainder;