Interested to Buy Any Domain ? << Click Here >> for more details...
if a column contains data like
ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to
place names separated by commas in another columns how can
we do?
- 2 Answers
- 8022 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapnil
By using stage variable in transformer
stg_name='' ( initialize)
stg_name=input.name : " , " : stg_name
_________
Transformer derivation
stg_name --> Target_name
| Is This Answer Correct ? | 4 Yes | 3 No |
What are stage variables, derivations and constants?
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
Terminate Activity
What is a folder? Difference types of stages?
what is use of SDR function?
How do u convert the columns to rows in datastage?
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
What are the main differences you have observed between 7.x and 8.x version of datastage?
I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 Answers Cognizant, IBM, TCS, Virtusa,
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
What are the different type of jobs in datastage?
Teradata 
