what are the enhancements made to Informatica 7.1.1 version
when compared to 6.2.2 version?



what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?..

Answer / shashiall

lookup on flat file in informatica7.1
no such provision in 6.1
union all trnasformation in 7.1 not in 6.1
transaction control tranformation not in 6.1
file reposioty in 7.1

Except to previous points.........

1. PMCMD: By using this option we can use parameter file at
command prompt. Why this needed suppose we are using more
than on parameter file, in such case we have to change the
parameter file in session properties. By this option u can
run from command prompt by changing parameter file, no need
to go to session properties.

2. Test load: we can test the load by taking the specified
no. of records.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,


Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,


Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,


When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  


Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  






What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,


In which scenario did u used Mapping variable?

1 Answers   Cognizant,


Explain sessions?

0 Answers  


What is the meaning of up gradation of repository?

0 Answers  


Why the workflow is failed after running two hours in informatica?

1 Answers   GE,


Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,


how to load duplicate row in a target

4 Answers  


Categories