Answer Posted / nams
It is just snapshot of runtime data as per business requirement
| Is This Answer Correct ? | 1 Yes | 3 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.
Explain entity, attribute and relationship in datastage?
How many Key we can define in remove duplicate stage?
What is job control?
Why do you need stage variables?
Why we use surrogate key?
What is the difference between operational data stage (ods) and data warehouse?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is orabulk stage?
Explain ibm infosphere information server and highlight its main features?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
State the difference between an operational datastage and a data warehouse?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are stage variables and constants?
Define ds designer?