how can we send even and odd records from a sequential file
to two different targets

Answer Posted / varma

In transformer specify constraints Mod(@INROWNUM,2) =1 for Odd records and Mod(@INROWNUM,2) = 0 for even records.

Is This Answer Correct ?    41 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How a source file is populated?

609


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1754


CHANGE CAPTURE

887


In Datastage, how you can fix the truncated data error?

640


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1627






What is meta stage?

577


Have you have ever worked in unix environment and why it is useful in datastage?

644


Can we use target hash file as a lookup ?

2814


Where do the datastage jobs get stored?

724


What are stage variables?

636


What is data partitioning?

739


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1895


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1040


To see hidden files in LINIX?

941


How we can covert server job to a parallel job?

593