Interested to Buy Any Domain ? << Click Here >> for more details...
I have a source table with column name CITY having 100
records,
I want target table with column name start with 'A'
and 'B',remaining columns as reject outputs.
how can achieve this by data stage?please help me?????
- 5 Answers
- 12708 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish
Job design will be:
seq --- Tx ---- target.txt
------rejct.txt
IN transformer use below constraint for target.txt
Left(city,1)='A' or Left(city,1)='B'
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
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
What are some prerequisites for datastage?
What are the stages in datastage?
what is the use of materialized view?
What are stage variables, derivations and constants?
what are the devoleper roles in real time? plz tell i am new to datastage....
How to implement complex jobs in data stage?
Difference between data warehousing and olap?
What are the repository tables in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
EXPLAIN SCD
How can we improve the performance in datastage?
What are routines in datastage? Enlist various types of routines.
What is merge stage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
