difference between informatica 8.6 and 9
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 difference between stored procedure transformation and external procedure transformation?
How many repositories can we create in Informatica??
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
how do the project develops? pls specify right from the start to end in step by steps.
Explain the use of aggregator cache file?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
What is parameter file?
How to Join Tables my Source is having 15 table target is one?
What are the different lookup cache(s)?