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
- 14381 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / eswar
this is not working plz explain clearly
| Is This Answer Correct ? | 0 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
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
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the flow of loading data into fact & dimensional tables?
What are the steps required to kill the job in Datastage?
How to reverse the string using SQL?
Explain the situation where you have applied SCD in your project?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the project in datastage?
What is ibm datastage?
what is the use of surogate key in datastage
What are constraints and derivations?
how to sort two columns in single job in datastage.
Explain usage analysis in datastage?
Where do you see different stages in the designer?
