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
- 8827 Views
- HSBC, I also Faced
- E-Mail Answers
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
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
sed,awk,head
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Can you define merge?
What are the components of datastage?
Name the different types of Lookups in Datastage?
in oracle target stage when we use load option and when we use upsert option?
root tree will find which is server job and which is parallel job?
What are the types of jobs we have in datastage?
What are the different common services in datastage?
What all the types of jobs you developed?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
AGGREGATOR default datatype
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.
Terminate Activity
