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?????

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

What is the different type of jobs in datastage?

0 Answers  


How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  


what r the sources u need to create the datastage?

1 Answers  


How to perform incremental load in datastage?

0 Answers  


Difference between server jobs & parallel jobs?

0 Answers  






which unix commands mostly used in datastage

3 Answers   HSBC,


i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,


how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,


there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,


what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,


I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  


What are the types of containers in datastage?

0 Answers  


Categories