Interested to Buy Any Domain ? << Click Here >> for more details...
difference between informatica 8.6 and 9
- 3 Answers
- 43984 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 is the sql query overwrite in source qualifier in informatica
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
What is the benefit of session partitioning?
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
Differentiate between joiner and lookup transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Can we combine a flatfile and a database table using an UNION transformation?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
What are the parts of Informatica Server?
What is meant by target load plan?
what is the main advantage of unconnected lookup
What is the session task and command task?
Teradata 
