5) A file contains 10 (1-10) I want trgt like
Trgt 1 trgt 2 trgt 3
1 2 3
4 5 6
7 8 9
10
Answers were Sorted based on User's Feedback
Answer / rambabubollineni
while that time we use transformer stage
in transformer stage we use function like mod(source
colname,3)=1 for first target.for2nd target we write
mod(s.col,3)=2,for3rd target mod(s.col,3)=0. fimally we get
results.
| Is This Answer Correct ? | 12 Yes | 1 No |
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?
how to create document in datastage?
What is Cleanup Resources and when do you use it?
What are datastage sequences?
Difference between in process and inter process?
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 r the stages mostly used in realtime scenarios
Why we use parameters instead of hard code in datastage.
i have the source from Uk,north america how can i pass the data two tables based on the locations
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
What is difference between server jobs & parallel jobs?