Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
- 1 Answers
- 3496 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / teju
take source sequential file with 1 rec and take target file with 100 records in between use a copy stage to map the source 1 rec to target 100 records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
options available in sequence job to run,validate?
CHANGE CAPTURE
What are data elements?
What are the types of containers in datastage?
What could be a data source system?
Define project in datastage?
what is ds administrator used for?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the differences between datastage and informatica?
What is the difference between validated and compiled in the datastage?
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
What are the types of hashed files in data stage
State the difference between an operational datastage and a data warehouse?
Describe stream connector?
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.
