Interested to Buy Any Domain ? << Click Here >> for more details...
difference between informatica 8.6 and 9
- 3 Answers
- 43986 Views
- Atos Origin, BA Continnum Solutions, Core Logic, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amar pandey
the major difference is lookup transformation which is
active(returns all the matched rows) in informatica 9.0
| Is This Answer Correct ? | 91 Yes | 8 No |
Answer / ramana
we can select distinct record using union trans in informatica 9x
| Is This Answer Correct ? | 2 Yes | 6 No |
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
What is a joiner transformation and why it is an active one?
what are the different types of transformation available in informatica and what are the mostly used ?
what is the complex transformation you used in informatica
Explain load alternative records / rows into multiple targets - informatica
What is union transformation in informatica?
How to extract original records at one target & Duplicate records at one target?
What is data movement mode in Informatica and difference between them?
In real time scenario where can we use mapping parameters and variables?
Teradata 
