Interested to Buy Any Domain ? << Click Here >> for more details...
col1
123
abc
234
def
jkl
768
opq
567
789
but i want two targetss target1 contains only numeric values
and target2 contains only alphabet values like
trg1
123
234
768
567
789
trg2
abc
def
jkl
opq
- 9 Answers
- 16250 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / prasad
hi shiva and srinu, its not work properly, would u plz
explain how to write the condition.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is job control?
What is the difference between validated and compiled in the datastage?
Explain the situation where you have applied SCD in your project?
What are the different types of lookups in datastage?
how to delete one row in target dataset
State the difference between an operational datastage and a data warehouse?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
how to add a new records into source?
Have you have ever worked in unix environment and why it is useful in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is orabulk stage?
Which algorithm you used for your hashfile?
Define data aggregation?
Can you define merge?
