1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / guest


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

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

What do mean by local and global repository?

0 Answers  

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,




How can you complete unrcoverable sessions?

1 Answers  

Tell me about MD5 functions in informatica

0 Answers  

What is DTM process?

4 Answers  

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

Explain the use of aggregator cache file?

0 Answers  

What is the difference between a router and a filter transformation?

1 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories