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..
- 2 Answers
- 10937 Views
- I also Faced
- E-Mail Answers
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 push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
data stores in which location while using data set stage as the target?
Define data aggregation?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How do you design PX Routines ?
whats relation between configuration file and datasets?
What is staging variable?
How to use Environment variable's in datastage?(use of process)
How to get max salary of an organization using data stage stages........... can any body help me plz.......
Teradata 
