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
- 12485 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
Terminate Activity
How to read the length of word in unix?
how to implement scd2 in datastage 7.5 with lookup stage
How to convert RGB Value to Hexadecimal values in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Differentiate between datastage and informatica?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Explain connectivity between datastage with datasources?
Why do we use link partitioner and link collector in datastage?
Have you used Unstructured data?
What are the difference types of stages?
what is the difference between == and eq in UNIX shell scripting?
How do u convert the columns to rows in datastage?
EXPLAIN SCD
