Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 3 Answers
- 9985 Views
- HSBC, I also Faced
- E-Mail Answers
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
What are the types of containers?
What are datastage sequences?
On which Dimension Table you implemented SCD Type in your Project
How you Implemented SCD Type 1 & Type 2 in your project?
Can you highlight the main features of ibm infosphere information server?
client know skid info?
How to Remove Duplicate using SQL?
Differentiate between operational datastage (ods) and data warehouse?
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...
State the difference between an operational datastage and a data warehouse?
Explain the situation where you have applied SCD in your project?
How do you start developing a datastage project?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is job control?
