what is the size of u r project? and what is the size of
source file?
Can we call a stored procedure from a unix script which is run using command task
Different circumstance which drives informatica server to expel records?
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
What is intricate mapping?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What is the need of an ETL tool?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
can a port in expression transf be given the name DISTINCT
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
What is the status code in stored procedure transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?