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
- 9977 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
Is it possible to query a hash file?
Name the third party tools that can be used in datastage?
How a source file is populated?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the difference between hashfile and sequential file?
Can you explain tagbatch restructure operator?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How many types of hash files are there?
What are iconv and oconv?
What is the difference between the local container and shared container?
What is job control?
What is the difference between in process and inter process?
Define project in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How do you schedule or monitoring the job?
