Sign Up Login


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

I have a source table with column name CITY having 100
records,
I want target table with column name start with 'A'
and 'B',remaining columns as reject outputs.
how can achieve this by data stage?please help me?????

Question Posted / vikram

Answers were Sorted based on User's Feedback



I have a source table with column name CITY having 100 records, I want target table with column..

Answer / bg

Job design will be:
seq --- Tx ---- target.txt
|_____ reject.txt

IN transformer use below constraint for target.txt

Left(city,1)='A' or Left(city,1)='B'

Check the otherwise and send it to reject file.

Is This Answer Correct ?    22 Yes 0 No

I have a source table with column name CITY having 100 records, I want target table with column..

Answer / satish

Job design will be:
seq --- Tx ---- target.txt
------rejct.txt
IN transformer use below constraint for target.txt

Left(city,1)='A' or Left(city,1)='B'

Is This Answer Correct ?    5 Yes 0 No

I have a source table with column name CITY having 100 records, I want target table with column..

Answer / naresh

Hi,

sequential-----filter------ds
in filter stage 
where clause= city like 'A%' OR CITY LIKE 'B%'

Is This Answer Correct ?    3 Yes 0 No

I have a source table with column name CITY having 100 records, I want target table with column..

Answer / rajesh reganti

Job design will be:
seq --- Tx ---- target.txt
------rejct.txt
IN transformer use below constraint for target.txt

City[1,1] = 'A' or City[1,1] = 'B'

IN transformer use below constraint for reject.txt
otherwise

Is This Answer Correct ?    2 Yes 0 No

I have a source table with column name CITY having 100 records, I want target table with column..

Answer / koti

seq---tx----target1
|
|
target2

In Transformer use below constraint for target1.txt

UpCase(DSLink3.Field001) [1,1]= "A" Or UpCase(DSLink3.Field001) [1,1] = "B"

In Transformer use below constraint for target2.txt

tick on otherwise/log

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers   Wipro,

what is combinability and non combinability?

2 Answers  

can we half project in parallel jobs and half project in server jobs?

4 Answers   Infosys, L&T,

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

how to run a sequential file stage in parallel if the stage is used on the TARGET side

0 Answers   Virtusa,

Can you explain tagbatch restructure operator?

0 Answers  

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

What is the difference between in process and inter process?

0 Answers  

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

what is a message handler

3 Answers   IBM,

What is the roundrobin collector?

0 Answers  

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

For more Data Stage Interview Questions Click Here
Categories