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

Can you filter data in hashed file?

0 Answers

how to run jon in unix back round process what is command use in runing a job?

2 Answers HSBC,

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers Wipro,

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers Accenture,

what is time dimension? and how to populate time demension

2 Answers TCS,

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers Infotech,

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers TCS,

How to Remove Duplicate using SQL?

0 Answers CTS,

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers IBM,

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers ME,

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers

ename like ibm,tcs,hcl need display those records only how?

2 Answers

For more Data Stage Interview Questions Click Here