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
What are the steps needed to create a simple basic datastage job?
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.
project Steps,hits, Project level HArd things,Solved methods?
How a routine is called in datastage job?
what is the use of skid in reporting?
How do you remove duplicate values in datastage?
What are the various kinds of the hash file?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How one source columns or rows to be loaded in to two different tables?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Why do we use exception activity in Datastage?
Can you explain repository tables in datastage?
What is a ds designer?
What is a merge?
What are the areas of application?