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
- 11875 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
State the difference between an operational datastage and a data warehouse?
What are sequencers?
What are system variables and sequencers in datastage
Define Job control?
What is active and passive stage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are stage variables and constants?
What is process model?
What is the method of removing duplicates, without the remove duplicate stage?
What is the purpose of pivot stage?
What are routines in datastage?
Differentiate between hash file and sequential file?
What is the difference between orabulk and bcp stages?
Can you filter data in hashed file?
How one source columns or rows to be loaded in to two different tables?
