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
- 12895 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define Job control?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
AGGREGATOR default datatype
Can you explain how could anyone drop the index before loading the data in target in datastage?
How many areas for files does datastage have?
Where do you see different stages in the designer?
Notification Activity
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are some prerequisites for datastage?
Enlist various types of routines in datastage.
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What could be a data source system?
What are the different kinds of views available in a datastage director?
What are the different type of jobs in datastage?
How do u convert the columns to rows in datastage?
