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
- 12638 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
Explain ibm infosphere information server and highlight its main features?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
AGGREGATOR default datatype
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Have you have ever worked in unix environment and why it is useful in datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
how to delete one row in target dataset
How to convert RGB Value to Hexadecimal values in datastage?
What is the purpose of pivot stage and types of containers in datastage
What is datastage engine?
Name the command line functions to import and export the DS jobs?
What a datastage macro?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is size of a transaction and an array means in a datastage?
