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...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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?

Question Posted / venkatreddy786

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

Difference between data warehousing and olap?

0 Answers  

why we use hash file for lookup?

5 Answers  

What is aggtorec restructure operator?

0 Answers  

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

client know skid info?

0 Answers   NTT Data,

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

0 Answers  

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

How to clean the datastage repository?

0 Answers  

Name the third party tools that can be used in datastage?

0 Answers  

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 Answers  

For more Data Stage Interview Questions Click Here
Categories