Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I am getting data from sequential file like below
column1
A&B
C&D
A&E
X&Y&Z
v&x
But I need the target column as like below
column1
A and B
C and D
A and E
X and Y and Z
v and x
- 7 Answers
- 10963 Views
- I also Faced
- E-Mail Answers
Answer Posted / lakshmi srinivas
By using convert function in transformer,we can implement
that....
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to implement complex jobs in data stage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
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
Can we use target hash file as a lookup ?
How rejected rows are managed in datastage?
What are the steps required to kill the job in Datastage?
How many types of hash files are there?
Describe the main features of datastage?
Why do you need stage variables?
What are sequencers?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are the important features of datastage?
What steps should be taken to improve Datastage jobs?
Difference between sequential file and data set?
