can we import source table without using source qualifier? if
yes then how? if no then why?
Answers were Sorted based on User's Feedback
how to improve performence by using sorted input in aggrigator t/r.
Can we override a native sql query within informatica?
what is unit testing?tell me proceedure
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
what is the hint? how to use it to reduce the query processing in program?
How do you manage the Parameter files while migrating your data from one environment to another environment?
what is the look up transformation?
How to generate sequence numbers using expression transformation?
in static and dynamic which one is better
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
Explain reference cursor?