In my project source data comes from MAINFRAME in files.so,This time data is c

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..

Question Posted / ashu_gang

2 Answers
11493 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary fi..

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

In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary fi..

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

Post New Answer

More Data Stage Interview Questions

convert yyyy mm dd to dd mm yyyy?

4 Answers

Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers

how can we extract data with out having any common column

7 Answers IBM, Switch2iTech,

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers Satyam,

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

0 Answers

What is a merge?

0 Answers

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers CGI,

I have a few records just I want to store each records tow times in target how?

2 Answers Polaris,

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers

How to create environments and call them? What is the use defined variables?

2 Answers HCL, ME,

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers HSBC,

Enlist various types of routines in datastage.

0 Answers

For more Data Stage Interview Questions Click Here