Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 8038 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / roshan nayak
To achieve this use "Convert" function.
ex - Convert('+-_()?','',NullToEmpty(Input_link))
this will convert "_" or any of the specify special
char-rector with empty string.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / 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 |
Answer / subhash
in your table any stage can be Executed this is like one table
here no logic and nnn_xx this like ename "they are specify ename like this only "
| Is This Answer Correct ? | 0 Yes | 2 No |
Which algorithm you used for your hashfile?
How to convert RGB Value to Hexadecimal values in datastage?
whats relation between configuration file and datasets?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
What is active and passive stage?
What are the various kinds of the hash file?
What is the flow of loading data into fact & dimensional tables?
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
how can we join one oracle & flat files ?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
Teradata 
