Hi Every one, I have a scenario plz suggest me 1)On daily we r getting som

Hi Every one,

I have a scenario plz suggest me

1)On daily we r getting some huge files data so all files
metadata is same we have to load in to target table how we
can load?

2) One column having 10 records at run time we have to send
5th and 6th record to target at run time how we can send?

Hi plz help me for above scenarios and If any one is having
JobSequence kindly send me one example and the scenario to
my mail ID(nrvdwh@gmail.com)

Question Posted / rajesh

3 Answers
8810 Views
HSBC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so..

Answer / vijayreddy

Hi Please find the dfd

seqfile--->T/R--->filter---->ds

in T/R stage u can take one etc column(SEQNO)that u can pass to next stage at same time u can create two stage varibles(sno1,sno2) this stage varibles u can call the filter stage in where class like(SEQNO between #sno1# and #sno2#

& then u can run job .That parameters values run time u can give the recored

Is This Answer Correct ?

0 Yes

0 No

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so..

Answer / akila ramu

Sample stage can be used for this. Sample stage when run in
period mode and N is mentioned, every Nth record from the
input is sent to the output.

For eg., period number=5 and maximum value=20 then 5, 10,
15 and 20th records are alone sent to the output.

Is This Answer Correct ?

1 Yes

1 No

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so..

Answer / ankit gosain

Hi All,

Ans1: In the source sequential file, you can specify the
read method from specific file to file pattern, so that it
can take the file on daily basis.
like:-you are getting the files ALSSM_12122012.dat,
ALSSM_13122012.dat, ALSSM_14122012.dat and so on which is
just appended by the date with file name. for this, you can
specify a file pattern like <path>/ALSSM_*.dat

Ans2: SeqFile--->Transformer--->Tgt
create two parameters of integer type in your job (say Val1
& Val2) &
In transformer stage, define a constraint:
@INROWNUM=Val1 OR @INROWNUM=Val2 (Where @INROWNUM is a
System Variable). Now you can assign the value of Val1 &
Val2 at the run time.

For more queries, mail me on ankitgosain@gmail.com

Cheers,
Ankit :)

Is This Answer Correct ?

2 Yes

2 No

Post New Answer