Interested to Buy Any Domain ? << Click Here >> for more details...
Hi I have scenario like this
s/r table T/r table
ename,sal empno,ename,sal
vijay,2000 1 , vijay, 2000
kumar,3000 2 ,kumar , 3000
ravi ,4000 3 ,ravi , 4000
How can i get target table like that without using
Transformer stage?
- 8 Answers
- 13258 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / surya
you can generate surrogate key in the transformer itself.
right click on the stage variables. tre you can find surrrogate key.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is active and passive stage?
What is the difference between the local container and shared container?
What is a datastage job?
In Datastage, how you can fix the truncated data error?
Can you explain how could anyone drop the index before loading the data in target in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
How do u convert the columns to rows in datastage?
What is the precedence of stage variables,derivations, and constraints?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is the difference between operational data stage (ods) and data warehouse?
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.
what is the use of materialized view?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
I have a few records just I want to store data in to targets cycling way how?
