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
- 12881 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 can you write parallel routines in datastage PX?
What is the difference between informatica and datastage?
Can you highlight the main features of ibm infosphere information server?
Where do you see different stages in the designer?
Differentiate between datastage and informatica?
How the ipc stage work?
how to delete one row in target dataset
Explain Quality stage?
How to read multiple files using a single datastage job if files have the same metadata?
how to sort two columns in single job in datastage.
What is the command line function to import and export the ds jobs?
How to convert RGB Value to Hexadecimal values in datastage?
What is the purpose of pivot stage and types of containers in datastage
Define meta stage?
what are the devoleper roles in real time? plz tell i am new to datastage....
