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
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Name the third party tools that can be used in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Can you implement SCD2 using join, transformer and funnel stage?
How to clean the datastage repository?
How to read multiple files using a single datastage job if files have the same metadata?
What are the different plug-ins stages used in your projects?
How do u convert the columns to rows in datastage?
Explain entity, attribute and relationship in datastage?
How do you import and export the datastage jobs?
how can we create rank using datastage?what is the meaning of rank?
What is the difference between hashfile and sequential file?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are routines in datastage? Enlist various types of routines.
On which Dimension Table you implemented SCD Type in your Project