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

Which warehouse using in your datawarehouse

1778


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

766


What is the difference between passive stage and active stage?

957


Distinguish between informatica & datastage. Which one would you choose and why?

663


What is a merge in datastage?

852






Define Data Stage?

741


What is the use of hoursfromtime() function in transformer stage in datastage?

668


What are the different common services in datastage?

826


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

622


what is the custome stage in datastage? how can we impliment that one? plz tell me

1998


Why do we use exception activity in Datastage?

873


table actions available in oracle connector?

1202


Can we use target hash file as a lookup ?

2919


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1861


what are the devoleper roles in real time? plz tell i am new to datastage....

1747