If 5 records are there in source, how will you make 10 in targets (double the number of records in source, duplicate source records)?

Anil

• Jun 22nd, 2016

We can do it by taking expression t/r and 2 instances of same target and connecting from same exp to 2 targets!

Anupam Kumar

• Apr 8th, 2016

Use Router. Create two group and just put TRUE in both

Answer Question  Select Best Answer

Which is the faster way - Adding a record at the beginning of a file or adding a record at the end of a file? Explain

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Feb 11th, 2011

Best way is to have a flag in the data to denote it is last row. =Powercenter reads till end of data and it reads in blocks, so it doesn't =expose the state of the last record.

Surya_prakash

 Profile Answers by Surya_prakash Questions by Surya_prakash

• Feb 10th, 2011

Adding index in to source qualifier and drop the index in the target table.

Answer Question  Select Best Answer