top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are the new features of Informatica 9.x in developer level?

+1 vote
317 views

What are the new features of Informatica 9.x in developer level?

posted Feb 25, 2015 by Sachin

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

1 Answer

+1 vote

New Features of Informatica 9.x in Developer level:

Now Lookup can be configured as an active transformation - it can return multiple rows on successful match.

Now you can write SQL override on un-cached lookup also. Previously you could do it only on cached lookup

You can control the size of your session log. In a real-time environment you can control the session log file size or time

Database deadlock resilience feature - this will ensure that your session does not immediately fail if it encounters any database deadlock, it will now retry the operation again. You can configure number of retry attempts.

answer Feb 25, 2015 by Manikandan J
Similar Questions
+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?

+1 vote
How to specify Row Delimeter while writing to file in informatica 9

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.

+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..

...