Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is
Empno
1
2
3
4
5
6
7
8
9
10
Answer Posted / vijau
in sequential file stage just execute unix command head -1 command
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
how many rows sorted in sort stage by default in server jobs
Differentiate between validated and Compiled in the Datastage?
What are routines in datastage? Enlist various types of routines.
What are the different options associated with dsjob command?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the difference between an operational datastage and a data warehouse?
What is difference between join, merge and lookup stage?
How can we improve performance of data stage jobs?
What are the processing stages?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is the flow of loading data into fact & dimensional tables?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are the types of containers in datastage?
What is the difference between account and directory options ?
What are stage variables, derivations and constants?