I have a file it contain 2 records like empname,company as
Ram, Tcs and Ram, IBM. But i want empname,
company1,company2 as Ram, TCS,IBM in the target. How?
- 6 Answers
- 12693 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / murali
Take the seq file stage and transformer and data set. in
transformer stage take two stage variables st1,st2 set the
intial value as '0' and data type is 'varchar' for st1
in st2 by using concatenate st1:',':st2
| Is This Answer Correct ? | 0 Yes | 12 No |
Post New Answer View All Answers
Describe stream connector?
Explain entity, attribute and relationship in datastage?
Explain Quality stage?
Can we use target hash file as a lookup ?
Define orabulk and bcp stages?
Can you explain link buffering?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
On which interface you will be working as a developer?
AGGREGATOR default datatype
How to read multiple files using a single datastage job if files have the same metadata?
Describe routines in datastage? Enlist various types of routines.
What is the difference between the local container and shared container?
What is meta stage?
What are datastage sequences?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
