Question { IBM, 4700 }

I have 2 tables. Table 1 is employee table and Table2 is
department table. In employee table i have 1,2,3,4,5 emp
id's,in Dept table i have various dept's like a,b,c and i
have 2,3,4 emp id's in my dept table.I joined with these 2
tables.I want the results for equi join means how many
records will fetch.In the same scenario i have to know the
left outer join, right out join and full outer join resuls
means how many records will come. can any body tell me the
answers

Answer

inner join :3 recorde
eno dept
2 a
3 b
4 c

leftouter join: 5records
1 NULL
2 a
3 b
4 c
5 Null

Rigt outer join: 3 records
2 a
3 b
4 c
Null d (if d is not assigned to any employee)

full outer join: 5records
1 Null
2 a
3 b
4 c
5 Null
Null d


Thank you.

Question { IBM, 10932 }

Out of 4 mill records only 3 mill records are loaded to
target
and then job aborted. How to load only those 1 mill(not
loaded records) for next run.
This job is not sequential job, it is stand alone parallel
job.What are the possibilities available in datastage8.1?

Answer

Check point option is for only for sequence jobs,
but not for the parallel jobs.

Question { IBM, 4977 }

WHY CANT WE SEE THE DATA IN DATASET

Answer

Dataset file is not a single file it is the combination
of the 3 fiels
1. data file, contains the data data in binary format wich is not in readable.
2. descriptor file, contains the configuration file(i.e no of partitions )
3. control file, which controls the information about both data and descriptor files.

To view the data in datasets in different ways
I. by using dataset management available in designer in tools.
II. In orchestrate execute the command $dump example.ds

cheers,
Bharath

Question { ABC, 10333 }

Is there any possibility to generate alphanumeric surrogate
key?

Answer

It is not possible to generate alphanumeric surrogate key
in datastage.

Question { CGI, 7052 }

how do u reduce warnings

Answer

In order to reduce the warnings you need to get clear idea
about particular warning, if you get any idea on code or
design side you fix it, other wise goto director-->select warning and right click and add rule to message, then click
ok. from next run onward you shouldn't find any warnings.

Question { 11719 }

How to remove blank spaces from data?

Answer

By using the following command you can remove blank lines from unix file:

$ sed 's/ *//g' sample

Question { 6524 }

how will u design file watch jobs?

Answer

Using Control-M Tool.