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 |
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
Why the workflow is failed after running two hours in informatica?
Define filter transformation?
What is target update override
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
In a sequential batch can you run the session if previous session fails?
What is a configuration management?
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
.prm wirh repalce .txt is possible?