1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / kiran

Answers were Sorted based on User's Feedback



col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only n..

Answer / mike

in transformer stage, used Alpha function which
Checks if a string is alphabetic or not. if its return
value is 1 then alphabetic.

Is This Answer Correct ?    8 Yes 0 No

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only n..

Answer / srinu

source->transormer->fileter1->transformer1
->filter2 ->tranformer2 joinstage ->target
in source:-
take i/p
transformer :
append new collumn and apply char function is alpha
filter1:
separate 0
filter2:
separate 1
transformer1
add another column @outrownum
transformer 2
add another column @outrownum
we join on @rownum column we will get
do perfect we get answer

Is This Answer Correct ?    1 Yes 0 No

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only n..

Answer / vaka

In Transformer stage, used Num function which
Checks if a string is alphabetic or not. if its return
value is 1 then alphabetic,0 then Numeric after using
filter give the where clause=0 output link 0(trg1) and
where clause=1 output link 1(trg2)
trg1
123
234
768
567
789

trg2
abc
def
jkl
opq

Is This Answer Correct ?    2 Yes 1 No

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only n..

Answer / eswar

this is not working plz explain clearly

Is This Answer Correct ?    0 Yes 0 No

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only n..

Answer / vijaya

Hi Eswar,

It works nicely.try once again

Is This Answer Correct ?    0 Yes 0 No

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only n..

Answer / shiva

In the transformer stage we have funcitons like alfa and
numaric so we go for that stage and write one condition if
alfa() then target1 and then go for constraints then put the
otherwise option then automatically numaric values will be
stored in anthor target table.

Is This Answer Correct ?    0 Yes 0 No

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only n..

Answer / 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

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only n..

Answer / 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

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only n..

Answer / srinu

at first generate row number column column 'number' then in transformer stage
create one column in constrains [ mod(number,2)=0] for this logic we get all even records mean all strings to one target
and for the second target kept a reject link all the numeric get a side

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

What is orabulk stage?

0 Answers  

I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

Which warehouse using in your datawarehouse

0 Answers   IBM,




Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  

What is job control?

0 Answers  

What is meta stage?

0 Answers  

CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

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

0 Answers  

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,

For more Data Stage Interview Questions Click Here
Categories