Interested to Buy Any Domain ? << Click Here >> for more details...
Hi every one, I am Suneel.
I/p o/p
--- -----
suneel suneel
suneel
suneel
suneel
suneel
how it will get.
Please design job with explain.
Thanks.
- 4 Answers
- 8412 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / shailesh
simplest solution that i can think of using ds8.1 pivot satge
seqfile--->pivot--->target
in pivot stage give the derivation for new_col as old_col,old_col,old_col,old_col,old_col (five times)
map it to target you will get the desired output
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the various kinds of containers available in datastage?
What is the difference between odbc and drs stage?
What is datastage?
what is repositery?
How to read multiple files using a single datastage job if files have the same metadata?
What is the purpose of pivot stage and types of containers in datastage
What is the difference between operational data stage (ods) and data warehouse?
On which Dimension Table you implemented SCD Type in your Project
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)
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
which r the connectors used in san?
Can you define merge?
How complex jobs are implemented in datstage to improve performance?
Different ways a project can be moved to production ?...example ….export-import and Version control.
