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
- 12699 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
Explain datastage architecture?
How can we improve the performance in datastage?
Why do we use link partitioner and link collector in datastage?
What is the command line function to import and export the ds jobs?
How to implement complex jobs in data stage?
Explain connectivity between datastage with datasources?
what is ds administrator used for?
Can we use target hash file as a lookup ?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is a datastage job?
What is job control?
Distinguish between informatica & datastage. Which one would you choose and why?
Define orabulk and bcp stages?
Can you implement SCD2 using join, transformer and funnel stage?
how to abort the job its matain duplicates?
