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.

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

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

Answer / eswar

this is not working plz explain clearly

Answer / vijaya

Hi Eswar,

It works nicely.try once again

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.

Answer / prasad

hi shiva and srinu, its not work properly, would u plz
explain how to write the condition.

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

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

how can we do null handling in sequential files

2 Answers   Reliance,

how to cleansing data

6 Answers   Cap Gemini,

sed,awk,head

0 Answers   CTS,

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

how to define satge variables in transformer stage

2 Answers  

Differentiate between odbc and drs stage?

0 Answers  

DataStage Scenario based Interview Questions

1 Answers  

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 Answers