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


Please Help Members By Posting Answers For Below Questions

Difference between sequential file and data set?

641


how to write server Routine coding?

1665


Define meta stage?

780


Define data aggregation?

664


What are the primary usages of datastage tool?

623






What are the job parameters?

703


How complex jobs are implemented in datstage to improve performance?

591


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)

2309


What is the difference between datastage and informatica?

609


What is the use of datastage director?

586


What is datastage?

647


what is the use of surogate key in datastage

1814


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?

1040


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3756


What is "fatal error/rdbms code 3996" error?

663