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
How a source file is populated?
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?
CHANGE CAPTURE
In Datastage, how you can fix the truncated data error?
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
What is meta stage?
Have you have ever worked in unix environment and why it is useful in datastage?
Can we use target hash file as a lookup ?
Where do the datastage jobs get stored?
What are stage variables?
What is data partitioning?
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)
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?
To see hidden files in LINIX?
How we can covert server job to a parallel job?