insequential file 2header avaliable,and 100 records
avaliable.how to skip the 2 headers and load 100 records
target?
- 5 Answers
- 8407 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manu
By using 'SED'command like this
for header sed -n '1|p’
| Is This Answer Correct ? | 3 Yes | 0 No |
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
What are the different layers in the information server architecture?
What are system variables and sequencers in datastage
What is a folder? Difference types of stages?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
which cache supports connected & un connected Lookup
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
What are transforms and what is the differenece between routines and transforms?
Teradata 
