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
What is the difference between operational data stage (ods) and data warehouse?
How can you write parallel routines in datastage PX?
What is difference between server jobs & parallel jobs?
project Steps,hits, Project level HArd things,Solved methods?
What are the steps needed to create a simple basic datastage job?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How you Implemented SCD Type 1 & Type 2 in your project?
what is the difference between == and eq in UNIX shell scripting?
What is the difference between odbc and drs stage?
Define Data Stage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees