Question { 48656 }

What is the minimum number of partitions you need to
install Linux?

Answer

only 2 are minimum required,
/
/swap

/ is for filesystems
/swap is temp memory that is RAM.

Question { pspl, 72916 }

Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Answer

1.SELECT ROWID FROM TABLE T1
WHERE ROWID NOT IN (SELECT MIN(ROWID)
FROM TABLE T2 WHERE T1.KEY=T2.KEY);

THIS QUERY IS USEFUL WHEN WE HAVE A KEY VAL.
2.
i.CREATE TABLE NEW AS SELECT DISTINCT * FROM OLD;
ii.DROP TABLE OLD;
iii.RENAME NEW TO ORIGINAL;
THIS IS WHEN WE APPLY TO DELETE DUPLICATE ROWS..

Question { Wipro, 23075 }

With out using Funnel Stage, how to populate the data from
different sources to single target

Answer

Hi kiran,

in one same job you create as follows,

seq1------>tseq1

seq2------>tseq2

step1:load first source into tseq1 as file name tgt.txt

step2:load second source into tseq2 as file name
tgt.txt(ensure file name first file name only)

step3:Give file upload mode=Append


run for one time you will get...

Question { 17875 }

What is the main difference between peek stage and copy
stage

Answer

In datastage both peek and copy stages are called stub stages.

Copy stage allows us to copy the input records into multiple o/p links, includes file stages or processing stages.

peek stage is one of the debug stage, which allows us to view
the sample no of records in log or to output file, but not to
any other processing stages.

Question { Cap Gemini, 9067 }

What is Horizontal transformation, vertical
transformation,diagonal transformation?

Answer

Instead of transformation use Combination in datastage,

Horizontal combining:
> join
> look-up
> merge
Vertical combining:
> remove duplicates
> Aggregation
Diagonal Combining:(not sure)
> vertical pivoting
> Horizontal Pivoting

Question { TCS, 8839 }

In datastage can ve find the job based on source table
name ??

Answer

Yes!,
There is an advance find option in top of the repository tab,
There we can find through source table name.

Question { 9002 }

Hi,
I am getting data from sequential file like below
column1
A&B
C&D
A&E
X&Y&Z
v&x
But I need the target column as like below
column1
A and B
C and D
A and E
X and Y and Z
v and x

Answer

hi,
please take a look on below,


seq_src------->ext_flter----->seq_tgt

in external filter give the
filter command = sed s/"&"/" And "/g command.

**Note: on ampersand (&) symbol you must give the double
quotes (""). With out this it doesn't populate.

Question { Polaris, 15337 }

my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?

Answer

It worked out for round robin also.. plz try..

Question { Polaris, 15337 }

my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?

Answer

Hi,

try this,

take two sequntial files, one as source and another as target
as follows

src_seq------------------->tgt_seq


in target give 4 target *.txt files.
give partition type as modulus or roundrobin..
try this...

Question { 6214 }

What is factless fact schema?

Answer

Fact less fact is nothing but the fact table that it doen't
contains any measures, but can see the count of occurring or
events are called Factless fact table.
example, ::No. of accidents in month.

if i elaborate it, number of accidents in one month give a basic count, by this you will not be able to make a business intelligence out of it. Hence this can not be a measurable.
It's just for statistical purpose. IN this case measurable is
"At what speed accidents took place?" here speed
is measurable fact i.e 75 kmph., 90 kmph., etc.,
based on speed factor you can have BI. Each event count of
accident is assigned to speed. hence BI says, by controlling
speed limit we can control accidents.
"This count of accidents is just statistical information
you can not control it directly.

Thank you.

Question { 6324 }

SOURCE LIKE
I_D,F1,F2
---------
100,N,Y
100,N,N
100,Y,N
101,Y,Y
101,N,Y
102,Y,N
103,N,N
104,Y,Y
105,N,N
106,N,Y
102,N,Y
105,Y,Y

O/P LIKE

ID flag1 flag2

101 Y Y
101 N Y
102 Y N
102 N Y
104 Y Y
106 N Y

Answer

Hi,
please find the below answer.

|------seq1
src---->trans-----
|------seq2


in transformer stage give constraint as follows

src.f1="N" And src.f2="N"

check other wise link on seq2link.

then you get..

Question { Wipro, 7347 }

I have source like col1,col2,col3,col4 and the values are like
3,6,1,7
1,5,3,8
2,1,5,6

i want the output like
3,6,7
5,3,8
2,5,6

How we will achieve in this scenario in informatica level.
Please help me..

Thanks in advance..

Answer

i don't know in informatica
in general approach,
concatenate all the columns into one column and strip the 1s
to empty string("")
and then seperate to each column one number on each column.

i hope it helps to u.


cheers!

Question { IBM, 11968 }

hi All,
i have one scenario like if

source--->transformer-->2 target sequential files

the 1 st target sequential file is loads the data from
source
and 2nd target sequntial file contain the 1st target total
record count,and file name of 1 st target seq file and
timestamp seperated by delimeter

for example if source have 10 record the 1st target seq
file hav 10 records
and
2nd target seq file example
10|xyz.txt|20101110 00:00:00

could you please help me out how can i implement in
datastage job.

Answer

Hi,
in derivation for seq2 give as follows,
for file name give job parameter as file name and datatype is char..
for timestamp give Current CurrentTimestamp()
for count rows it is not not possible by using transformer
it can be achieved by adding another stage
that is aggregation stage..

Question { IBM, 10402 }

There are two file are there .1st file contains 5 records and
2nd file contain 10 records in target they want 50 records.how
can achieve this

Answer

Use query
>select * from tab1,tab2;

You get Cartesian Product of two table rows
if tab1 having m no.of an tab2 has n no of col
then mXn (m by n) rows are returned.

Question { 9104 }

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.

Answer

If src have n no. of records then how will u do the same?