Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Hi all, can u explain header and trailer records in file?
If a file has header and trailer /master-detail records how
will you read it in datastage?

Answers were Sorted based on User's Feedback



Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-..

Answer / datastage4you

Whenever there is any header and footer with file, those must identifiable like First line will be header or last line will be footer or by some column info (row type)

so if data follows first criteria, use unix or datastage head and tail to extract those

thanks
www.datagenx.net

Is This Answer Correct ?    2 Yes 0 No

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-..

Answer / subhash

Header: is nothing but Column names/Structure of the table
trailer: is something like FOOTER of the page/file

if file has Header, while reading the file set 'TRUE' for
'First Line is Column names'--

If set true, the first line of a file contains column names on
writing and is ignored on reading.

Is This Answer Correct ?    3 Yes 2 No

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-..

Answer / sreeni

We can use Read Method:Whether to specify filename:"Path"
Options we can use filter option to remove header & footer
using unix command "sed 1d;$d"

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What are the types of views in datastage director?

0 Answers  


how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,


What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,


Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,


What are the components of datastage?

0 Answers  


what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,


Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,


1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,


Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  


What are the types of jobs we have in datastage?

0 Answers  


What are stage variables and constants?

0 Answers  


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

6 Answers  


Categories