Interested to Buy Any Domain ? << Click Here >> for more details...
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?????
- 5 Answers
- 12554 Views
- I also Faced
- E-Mail Answers
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
In Datastage, how you can fix the truncated data error?
What is datastage?
Describe link sort?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How to implement complex jobs in data stage?
What is ibm datastage?
Differentiate between validated and Compiled in the Datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How to clean the datastage repository?
What is the difference between account and directory options ?
Describe stream connector?
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?
What is the difference between orabulk and bcp stages?
How to read multiple files using a single datastage job if files have the same metadata?
What are the different plug-ins stages used in your projects?
