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
- 12719 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 |
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
how to find diff between 2 dates without using Icon... funtions?
How to create a doccument in datastage?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
How many areas for files does datastage have?
WHAT are unix quentios in datastage
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
what is the best stage in datastage parller jobs to use full out join and why
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
Teradata 
