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)
Answer Posted / 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 View All Answers
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the different common services in datastage?
What is meta stage?
What are the repository tables in datastage?
I have a few records just I want to store data in to targets cycling way how?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the difference between validated and compiled in the datastage?
how to write server Routine coding?
What is use Array size in datastage
Explain datastage architecture?
What is the difference between informatica and datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How a server job can be converted to a parallel job?
Explain Quality stage?