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
- 12484 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the difference between Datastage 7.5 and 7.0?
What are stage variables and constants?
project Steps,hits, Project level HArd things,Solved methods?
What is the difference between validated and compiled in the datastage?
What is the sortmerge collector?
Name the different types of Lookups in Datastage?
what is flow of project?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how can we create rank using datastage?what is the meaning of rank?
what is the use of skid in reporting?
Highlight the main features of datastage?
What is the method of removing duplicates, without the remove duplicate stage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Different ways a project can be moved to production ?...example ….export-import and Version control.
