Search Results

hi,

Apologies if this has been covered.
I have requirement where i have to convert a single column into multiple column.
My data will be like this -
2
3
4
5
6

Output required -
2 3 4...

hi ,
i need to convert fixed length file to delimited file using unix where length of each column is variable

i have a file having 30 million records.i want to generate a file having say 5% of total records in another file. the records in the new file shud be randomly generated.

Hi

I want to pass variables with the NR function in awk command.

test_file1 is input file having 500 records.
var1=100.
var2=200

awk -F" " 'NR >= $var1 && NR <= $var2' test_file1 >...

hi,

i want to call unix script from transformations used in informatica mapping?

can we do it in any way? Please reply ASAP.

We cant use Storep procedure transformation

Thanks in...

two files a.txt and b.txt .

data of a.txt :
mango~select * from employee
apple ~ select * from student

data of b.txt :

mango~select * from emp1

mango.xml is an informatica mapping...

one error was there the txt file will not contain .xml extension. It will have only name that is mango.
Also wanted we are oing an ETL mapping in informatica, ehen we export it, it gets save into...

Hi,

Suppose there are two files a.txt and b.txt
a.txt contains name and corresponding query (delimited by |)
Ex- mango.xml|select * from employee

b.txt contains data such as

...