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

Answer Posted / rikan

same task without using transformer stage.

Source---->column generator stage--->filter stage---->2 targets

in column generator stage, select column tab, there create
column like skey and double click on starting point of that
row,we can get the metadata ,modification window--->there we
can give cycle=1 increment by 1 and ok.write the condition
in filter stage .we can get correct out put.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

954


How do you generate sequence number in datastage?

625


Explain the importance of surrogate key in data warehousing?

715


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1631


Why we use surrogate key?

699






What are the various kinds of the hash file?

664


How many areas for files does datastage have?

644


What are some prerequisites for datastage?

617


What are the processing stages?

644


Terminate Activity

841


What is usage analysis in datastage?

818


Different ways a project can be moved to production ?...example ….export-import and Version control.

1935


How many types of views are there in a datastage director?

834


On which interface you will be working as a developer?

639


Why fact table is in normal form?

676