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?????
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
What are sequencers?
Could anyone give brief explanation bout datastage admin
in oracle target stage when we use load option and when we use upsert option?
What is the difference between informatica and datastage?
client know skid info?
What are system variables and sequencers in datastage
Distinguish between informatica & datastage. Which one would you choose and why?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How to reverse the string using SQL?
Difference between in process and inter process?
What is the use of datastage director?
What are the partitioning techniques available in link partitioner?
How can you write parallel routines in datastage PX?
What is orabulk stage?
Is the value of staging variable stored temporarily or permanently?