I have a source table with column name CITY having 100
records,
I want target table with column name start with 'A'
and 'B',remaining columns as reject outputs.
how can achieve this by data stage?please help me?????
Answer Posted / satish
Job design will be:
seq --- Tx ---- target.txt
------rejct.txt
IN transformer use below constraint for target.txt
Left(city,1)='A' or Left(city,1)='B'
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
AGGREGATOR default datatype
Can you explain engine tier in information server?
Describe link sort?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Define meta stage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the difference between the local container and shared container?
How do you start developing a datastage project?
Explain entity, attribute and relationship in datastage?
What is the difference between passive stage and active stage?
How to perform incremental load in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is ibm datastage?