In my project source data comes from MAINFRAME in
files.so,This time data is coming as a binary file...I know
for binary data we use Complex flat file stage..I have used
it also..but on 'view data' data is not coming
correctly..as it in MAINFRAME.give me some ideas..
Answers were Sorted based on User's Feedback
Answer / hussy
To read a Mainframe file you need a copybook of that file.
what I mean to say is metadata of that particular file. As
it will be in the cobol format (where levels are defined).
But there is possibility of reading Mainframe file without
using copybook but needs lot of effort.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dhrubajyoti ghosh
just give me some sample data like mainfrem file
or u can pares data 1st with the help of shell scripts
into a flat file
| Is This Answer Correct ? | 1 Yes | 1 No |
what is meta data? Explain? Where it is used?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
job locking methods? How can we unlock the job?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
If you want to use the same piece of code in different jobs, how will you achieve it?
Triggers,VIEW,Procedures
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
How to Remove Duplicate using SQL?
Explain the importance of surrogate key in data warehousing?
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
What are the enhancements made in datastage 7.5 compare with 7.0?
how to cleansing data