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
- 11958 Views
- I also Faced
- E-Mail Answers
Answer Posted / koti
seq---tx----target1
|
|
target2
In Transformer use below constraint for target1.txt
UpCase(DSLink3.Field001) [1,1]= "A" Or UpCase(DSLink3.Field001) [1,1] = "B"
In Transformer use below constraint for target2.txt
tick on otherwise/log
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to Remove Duplicate using SQL?
What are the functionalities of link partitioner?
What are datastage sequences?
Enlist various types of routines in datastage.
What is the roundrobin collector?
Name the third party tools that can be used in datastage?
What is the difference between informatica and datastage?
What are the different type of jobs in datastage?
What are data elements?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How to read multiple files using a single datastage job if files have the same metadata?
Differentiate between validated and Compiled in the Datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is usage analysis in datastage?
