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,
i have one scenario like if

source--->transformer-->2 target sequential files

the 1 st target sequential file is loads the data from
source
and 2nd target sequntial file contain the 1st target total
record count,and file name of 1 st target seq file and
timestamp seperated by delimeter

for example if source have 10 record the 1st target seq
file hav 10 records
and
2nd target seq file example
10|xyz.txt|20101110 00:00:00

could you please help me out how can i implement in
datastage job.

Answer Posted / kirill lychagin

I managed to make such job in IIS 8.5, but i think it can be reproduced in all 8.* versions/

Main question is how to get rows count in transformer. In general it can't be done. But we have sequential file stage as target.

So my solution:
1) name of 1st target file is job parameter.
2) on link to 2nd target file we add to columns:
FNAME=#FIRSTTARGETFILE# - name of 1st target file
ROW_NUM=@INROWNUM - number of input row
3) on input link to 2snd sequntial file set Collector Type=Ordered and set ROW_NUM as sort key column
4) Then in 2nd Sequntial File Stage at tab Properties add "Filter" in Options category and write there "head -n 1"

Profit!

SO the idea is to get column num in transformer and apply unix style filter (mks on Windows) on output to Seq File.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2214


Explain entity, attribute and relationship in datastage?

1113


Define oconv () and iconv () functions in datastage?

1420


What is a ds designer?

1073


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

935


What are the functionalities of link partitioner?

1027


What is apt_config in datastage?

1146


Can you explain repository tables in datastage?

1415


What is the difference between an operational datastage and a data warehouse?

1160


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3804


How to convert RGB Value to Hexadecimal values in datastage?

4003


Define project in datastage?

1103


how do u catch bad rows from OCI stage? And what CLI stands for?

2804


Define ds designer?

1286


Explain Quality stage?

1162