I have 5 different sources i want same records in 5 different
targets Can you any body send me this question answer
rathdsetl@gmail.com
Answer Posted / subhash
Qns is not clear, as per my understandings:
connect 5 sources(if they have same metadata) to funnel
funnel to copy stage
copy stage to 5 diff targets
then u will get same data in 5 targets.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
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 to read multiple files using a single datastage job if files have the same metadata?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the difference between orabulk and bcp stages?
What a datastage macro?
Difference between sequential file and data set?
why do u need the IOS upgradation in a FC switch
How do you run datastage job from the command line?
Have you have ever worked in unix environment and why it is useful in datastage?
How do you register plug-ins?
Define data aggregation?
What is the difference between operational data stage (ods) and data warehouse?
Explain how a source file is populated?
Difference between data warehousing and olap?
What are some prerequisites for datastage?