repeating the records

san_dwh · Post by **san_dwh** » Fri Jan 21, 2011 5:57 am

In sequential file,I have one row. In the target, I need 10 records.
like this..
source target
colom colom
xyz xyz
xyx
.
.
10 times
I know one solution that is taking a copy stage mapping 10 times to funnel then target.
Is there any other simple solution?
please help me
thanks
santhosh

chulett · Post by **chulett** » Fri Jan 21, 2011 8:10 am

Horizontal Pivot, i.e. rows to columns.

ray.wurlod · Post by **ray.wurlod** » Fri Jan 21, 2011 1:54 pm

Another interview question?

san_dwh · Post by **san_dwh** » Sun Jan 23, 2011 5:21 am

thank you

san_dwh · Post by **san_dwh** » Sun Jan 23, 2011 5:23 am

yes. I am getting a lot from dsxchange