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
- 12475 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 do u convert the columns to rows in datastage?
sed,awk,head
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the difference between datastage and informatica?
What steps should be taken to improve Datastage jobs?
What are the various kinds of containers available in datastage?
What is merge stage?
How do you register plug-ins?
How do you import and export the datastage jobs?
How to convert RGB Value to Hexadecimal values in datastage?
What is datastage?
What is the difference between passive stage and active stage?
How to clean the datastage repository?
How you Implemented SCD Type 1 & Type 2 in your project?
Triggers,VIEW,Procedures
