Question { IBM, 5320 }

what is meant by data driven.. in which scenario we use
that..?

Answer

Data driven is nothing but but instruct the source rows that
should take action on target i.e(update,delete,reject,insert).
If we use the update strategy transformation in a mapping then
will select the datadriven option in session.

reply me if am wrong
teja_dwh@yahoo.com

Question { 7587 }

In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?

Answer

use this query u will get this.For example i am taking emp
table

select * from emp where rowid not in(select max(rowid) from
emp group by empno)

Question { Syntel, 9869 }

I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?

Answer

By using sequence generator properties we can do this.
setting the properties like below
start value:1
end value:3
cycle:yes
reset:yes
increment by:1
we can achieve the result by this way.

cheers
teja

Question { Patni, 8512 }

in flatfile target how can u create header and footer plese
give me the comands how will u write in session properties

Answer

by using session properties we can create header and footers
for flat file.
we can take column names as header etc.

reply me if am wrong
teja_dwh@yahoo.com

Question { 4969 }

how can import the data from the flat files?

Answer

the file has to be exist in your machine.then import file same
as database table.to import specify the path.