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


Please Help Members By Posting Answers For Below Questions

What is the difference between validated and compiled in the datastage?

703


What is the difference between datastage and informatica?

612


How many types of hash files are there?

612


What is the project in datastage?

667


What is ibm datastage flow designer?

687






hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1469


what is flow of project?

1559


What are routines in datastage? Enlist various types of routines.

627


What are stage variables and constants?

702


What is apt_config in datastage?

702


What is quality stage?

574


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1756


What is difference between symmetric multiprocessing and massive parallel processing?

653


What are the different kinds of views available in a datastage director?

605


Differentiate between datastage and datastage tx?

599