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
Answer Posted / 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 |
Post New Answer View All Answers
explain about citrix scheduling tool in datastage
Whats difference betweeen operational data stage (ods) and data warehouse?
How do you schedule or monitoring the job?
What are the functionalities of link collector?
Highlight the main features of datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the project in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
which r the connectors used in san?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the process of killing a job in datastage?
How to reverse the string using SQL?
Difference between data warehousing and olap?
Enlist various types of routines in datastage.