how many types transformations supported by sortedinput?
Answers were Sorted based on User's Feedback
Answer / mansi
Aggregator Tranformation,Joiner Tranformation and Lookup
Tranformation support sorted input.
So that it will increase the session performance.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / mansi
Aggregation Transformation supports sortedinput.
So that it will increase the performance.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prasanth
aggrigator,joiner and lookup only three transformations are
supported
| Is This Answer Correct ? | 1 Yes | 0 No |
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
Explain incremental aggregation in informatica
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
What is a difference between complete, stop and abort?
What is difference between partioning of relatonal target and partitioning of file targets?
How to create the source and target database connections in server manager?
How you count the number of records available at your source?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
What are the restrictions of union transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?