insequential file 2header avaliable,and 100 records
avaliable.how to skip the 2 headers and load 100 records
target?
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 |
wt is the difference between swith and filter stage
Have you used Unstructured data?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
what is a force compile
How do you schedule or monitoring the job?
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
what is use of SDR function?
HOW CAN WE SEE THE DATA IN DATASET?
In one project how many shared containers are created?
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?
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance