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
- 12480 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bg
Job design will be:
seq --- Tx ---- target.txt
|_____ reject.txt
IN transformer use below constraint for target.txt
Left(city,1)='A' or Left(city,1)='B'
Check the otherwise and send it to reject file.
| Is This Answer Correct ? | 22 Yes | 0 No |
Answer / satish
Job design will be:
seq --- Tx ---- target.txt
------rejct.txt
IN transformer use below constraint for target.txt
Left(city,1)='A' or Left(city,1)='B'
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / naresh
Hi,
sequential-----filter------ds
in filter stage
where clause= city like 'A%' OR CITY LIKE 'B%'
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rajesh reganti
Job design will be:
seq --- Tx ---- target.txt
------rejct.txt
IN transformer use below constraint for target.txt
City[1,1] = 'A' or City[1,1] = 'B'
IN transformer use below constraint for reject.txt
otherwise
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What is the use of surrogate key stage?
Can aggregator and transformer stages use to sort the data? How ?
How will you move hashed file from one location to another location?
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
What is staging variable?
Describe the architecture of datastage?
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
Two source files contains same meta data third file contains different data types can I funnel that file.
What are the different database update actions available?
whats relation between configuration file and datasets?
Unix command to view the data in a dataset
how to convert rows into columns
Teradata 
