Question { TCS, 29340 }

if we create a file, in that 10 rows(means 1,2,....9,10
like). i want 7 row exactly, which command use in unix?
plz send this question.

Answer

hi isha,

this is prasad, head command displays first n lines from
the file

head -7 it displays first 7 lines, i want exact
7 line.


thanku for send this question isha.

Is This Answer Correct ?

7 Yes

4 No

Question { TCS, 29340 }

if we create a file, in that 10 rows(means 1,2,....9,10
like). i want 7 row exactly, which command use in unix?
plz send this question.

Answer

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

Question { 8243 }

i have source like
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100

i want target like

target1
deptno,sal
1,2000
3,4000
4,5000

target2
2,3000
1,2300
5,1100


with out using transformerstage

Answer

1)First go to Seq File-->Columns-->Add RowNum column and
2)then go to Properties-->select Options-->select Row Number Column=RowNum (Drop down list select RowNum column)
we will get the sequence Numbers.

first do the link sort for Sal in transformer stage.

and in Transformer stage go to
Constraint: Mod(dslink1.RowNum,2)=0 ---o/p1

and then select otherwise check box or write Mod(dslink1.RowNum,2)=1 --->0/p2

Question { Patni, 13660 }

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

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

Question { Cap Gemini, 8592 }

i have one table with one column in this column i have three
rows like 1,1,2 then that rows populate to target as first
tow rows as one row and remaing row as one row how it posible?

COLUMN_NAME
SHIVA
RAMU
MADHU

THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND
MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

Answer

Question is not clear.

U want 1,1 records goes to one target and duplicate records goes to another target, is it right? can u plz conform this and just let me know?

Question { IBM, 10748 }

one file contains
col1
100
200
300
400
500
100
300
600
300
from this i want to retrive the only duplicate like this
tr1
100
100
300
300
300 how it's possible in datastage?can any one plz explain
clearley..........?

Answer

Job Design:

|----->Agg--->Filter1-->|
| |
| |
file-->cp-------------------->Join---->Filter2---->target

Agg: use aggregator and select Agg_type=count rows and then give the Count O/P column=Count (User defined).

Filter1: give the condition Count<>1

Join: select left outer join

Filter2: give the condition Count<>0

u will get the right output....what ever the duplicate records.

and if u want unique records, give the condition Count=0

Question { 6424 }

in one scenario source flat file like
Fileld1
00122001550056200568
00256002360014500896
00123004560078900258
00147004560025800256
divide each 5 numbers as one column i.e
here i need
field1 field2 field3 field4
00122 00155 00562 00568
00256 00236 00145 00896
00123 00456 00789 00258
00147 00456 00258 00256
plz help me....

Answer

Take 4 field names(field1 field2 field3 field4) in output stage.

use Transformer stage: In Derivation use the below substring

Field1: SourceColumn[1,5]
Field2: SourceColumn[6,10]
Field3: SourceColumn[11,15]
Field4: SourceColumn[16,20] use this one u will get correct o/p.

Question { Wipro, 8194 }

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

Answer

use column datatype as varchar

DateToString(StringToDate(DSLink3.DateColumn,'%dd-%mm-%2000yy'),'%mmm-%dd-%yyyy')

use above format in derivation for transformer stage, u will get the desired output.