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 |
What is the difference between informatica and datastage?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
Have you used Unstructured data?
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
how to cleansing data
what is a message handler
Enlist various types of routines in datastage.