Suppose take my name "Reddyvaraprasad"
From source it is coming Reddy vara prasad
Need to get As Reddyvara prasad/
Answers were Sorted based on User's Feedback
Answer / akila
Create 3 stage variables to split the name into three and
then concatenate
SV1 = Field(NAME," ",1)
SV2 = Field(NAME," ",2)
SV3 = Field(NAME," ",3)
Then concatenate in the column derivation as sv1:sv2:" ":sv3
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / hussy
I am sowwie akila. tat was the correct answer mistakenly I
have clicked on the other option. hope u dont mind
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vaibhav
Hi Akila,
What if input name comes as Ajay Rathore... Surname should be differentiated with space and middle name should be concatenated with first name...then this solution might be wrong...
Is This Answer Correct ? | 0 Yes | 0 No |
How many types of hash files are there?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
whats difference between ls -ltr and ls -lrt?
How do you import and export data into datastage?
What are the different common services in datastage?
how to call sequential generator in datastage?
What are the partitioning techniques available in link partitioner?
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 is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
What is the process of killing a job in datastage?
How did you reconcile source with target?
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please