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
- 13537 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
why do u need the IOS upgradation in a FC switch
What is difference between server jobs & parallel jobs?
Why do you need stage variables?
how to delete one row in target dataset
Explain connectivity between datastage with datasources?
How many Key we can define in remove duplicate stage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Explain usage analysis in datastage?
Terminate Activity
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are some different alternative commands associated with "dsjob"?
What is the difference between server job and parallel jobs?
What are the different common services in datastage?
