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
Answer Posted / kiran
By using transformer stage we can implement this
in transofrmaer functions like alfa funcation
and numric functions these functions are using to
implement this
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
On which Dimension Table you implemented SCD Type in your Project
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
How do u convert the columns to rows in datastage?
What are the different options associated with dsjob command?
Differentiate between hash file and sequential file?
Can you implement SCD2 using join, transformer and funnel stage?
how to abort the job its matain duplicates?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How many Key we can define in remove duplicate stage?
What is merge stage?
Name the different sorting methods in datastage.
What is the different type of jobs in datastage?
What is a ds designer?
EXPLAIN SCD
what is repositery?