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
- 11018 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 |
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
1)Source file contains one record, I want 100 records in target file.
What are the benefits of datastage?
How one source columns or rows to be loaded in to two different tables?
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
how to transfer file from one system to another system in unix? which cmd to be use?
how to load meta data
Is possible to create skid in dim,fact tables?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
How can one find bugs in job sequence?
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
What is audit table?
Teradata 
