Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11605 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 |
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
root tree will find which is server job and which is parallel job?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
What is the roundrobin collector?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
How do you import and export data into datastage?
what is the main differences between Lookup, Join and Merge stages?
Triggers,VIEW,Procedures
Teradata 
