top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to specify Row Delimeter while writing to file in informatica 9

+1 vote
340 views

I have data with only 1 column and about 50 rows in it like

col
-----------
ab~~8900~~iop
nmk~~?~~ioiooo
king~~till~~8899089

the data will have column delimeters(i.e~~) but i will not seperate them. I have to clean the data and write to file after cleaning But the output file should be like

 col
 ------
 ab~~8900~~iop#^#nmk~~?~~ioiooo#^#king~~till~~8899089
The row delimeter here is #^#

How can i get this done.

Please suggest.

posted Jun 18, 2014 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

If you really need PowerCenter for this (why not write a simple shell script instead), you can use a variable port to concatenate the source rows + #^# into a single value and then aggregate the rows on some dummy, constant value to take the last row.

answer Jun 20, 2014 by Shweta Singh
Similar Questions
+3 votes
Specifying Source file name using parameter variables in informatica 9?

I have a mapping like
SA-->SQ--->EXPR--->TGT

The source will be of the same structure and the tartget also.
There are a bunch of files(with the same structure) which will go through this mapping .
So i want to use a parameter file through which i will give the file names for every run manually.

How to use the param file in session for Source filename attribute
Please suggest..

+1 vote
How to extract the number(0-9) from the string in informatica?

I want to extract the number(0-9) from the string. e.g.
1.if src is *J$456*&56 then tgt should be 45656
2.if src is &*(>123>>789&^ then tgt should be 123789

This is just an example, special characters or alphabets are random in string, so how to extract only numbers?

0 votes
how to implement row level summmary function in informatica

Can someone please explain me how to implement the following logic in informatica. but Not with source qualifier with other transformations inside the mapping.

SUM(WIN_30_DUR) OVER(PARTITION BY AGENT_MASTER_ID ORDER BY ROW_DT ROWS BETWEEN 30 PRECEDING AND 1 PRECEDING)

Basically this is sql(oracle) level requirement but i want at informatica level.

+2 votes
Error while reading source file name starts with a number in informatica

The source file name in my project starts with a number for example 20070908abcd.csv. Informatica is not allowing to read the source in the designer and displays the following message:
The first character in this name cannot be a number.

Could you please let me know how to handle as many source files are of this format?

+1 vote
How to pivot row data using Informatica?

How can I pivot row data using Informatica PowerCenter Designer? Say, I have a source file called address.txt:

+---------+--------------+-----------------+
| ADDR_ID |     NAME     |     ADDRESS     |
+---------+--------------+-----------------+
|       1 | John Smith   | JohnsAddress1   |
|       1 | John Smith   | JohnsAddress2   |
|       2 | Adrian Smith | AdriansAddress1 |
|       2 | Adrian Smith | AdriansAddress2 |
+---------+--------------+-----------------+

I would like to Pivot this data like this:

+---------+--------------+-----------------+-----------------+
| ADDR_ID |     NAME     |    ADDRESS1     |    ADDRESS2     |
+---------+--------------+-----------------+-----------------+
|       1 | John Smith   | JohnsAddress1   | JohnsAddress2   |
|       2 | Adrian Smith | AdriansAddress1 | AdriansAddress2 |
+---------+--------------+-----------------+-----------------+

How can I do this in Informatica?

...