how can we send even and odd records from a sequential file
to two different targets
Answer Posted / deepu
we can use transfarmer stage,in the stage create surgatekey
and write constraint like mod(<surcatekeycolumn>/2)=0 in
one link and mod(<surgatekeycolumn>/2)=1 in another link.we
get even records and odd records
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the components of datastage?
What is difference between join, merge and lookup stage?
Where the datastage stored his repository?
How rejected rows are managed in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
CHANGE CAPTURE
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?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is usage analysis in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is job control?
What is the difference between account and directory options ?
What is the differentiate between data file and descriptor file?
What is a ds designer?
Lookup constraints