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 / 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 |
Post New Answer View All Answers
How to implement complex jobs in data stage?
What is the flow of loading data into fact & dimensional tables?
What is the difference between an operational datastage and a data warehouse?
what are the errors,warnings in datastage
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How to RD using transformer?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the difference between passive stage and active stage?
how to export or import the jobs in .ISX file
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Have you have ever worked in unix environment and why it is useful in datastage?
How to manage date conversion in Datastage?
Explain connectivity between datastage with datasources?
How do you generate sequence number in datastage?
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?