i want anser this question empno,ename,sal 12,mmm_ww,200
13,nnn_xx,300 14,bbb_qq,400 which stages are take which
types of logicks are doing pls help me i don't need "_"ex
nnnxx this type i want
Answer Posted / venugopal
In the transformer stage use field function to remove "-"
and get the proper o/p... it will help u...
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How many types of hash files are there?
What are data elements?
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 steps should be taken to improve Datastage jobs?
How can one find bugs in job sequence?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are the processing stages?
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
How do you start developing a datastage project?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Distinguish between informatica & datastage. Which one would you choose and why?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How a server job can be converted to a parallel job?
What are the job parameters?