Search:

Hi,

cat $filename | sed 's/^Hello//'

The above code displays the filename, which acts as input to sed. This sed here searches for the occurance of the word Hello at the beggining (^ ->this...

Hi buddy,
I discussed about this issue and just now came to know that one source instance can have n number of files as input. The only way to handle changes in the file input is changing in the...

I think one source instance can take up only one file as input. If there exsits a way, please update me with the same.

Thanks,
Divya :)

Yes you can always do incremental load no matter your target and source are flat files are not. But make sure to check the Append if Exists in session properties in mappings tab for target. And one...

Thanks Beena. Is there any query describing the primary keys of the table??

Hi friends, i want a query to know the table structure in db2 listing all its columns, primary keys and all. I tried using the query describe table table_name i get the following o/p...

thanks buddy, You are helpful. :)

Hi friends,

I came across a strange thing today. There was a query

select *from emp order by name,sal --

I dnt know what does -- stand for in the above query. I couldnt find out the...

I dnt know about Round Robin thing. You can achive this by using sequence generator transformation..
1) Import ur source table.
2) create a sequence generator transformation start by one n...

Hi Raju,

Can u please explain me how to use Round robin partition. I am novice to DW and never heard of this before.

Thanks in advance,
Divya

use the query below, Its in Db2

select rollno,name,marks from table_name order by marks asc

cheers,
Divya

Just use a update transformation and give the option dd_update in Update strategy expression, when u run it new records get inserted or old ones get updated. I dnt think there is a need for lookup...