If we use sorted ports in aggregator transformation
and somehow records are not in order by format so what
will happen,session fails or it succeeded with incorrect data?

Answer Posted / akhil4

session will be failed,when ever u enable the sort ports option u can use "sorter transformation" before "aggregator trns" that time session will be run.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1528


What are the new features of informatica 9.x in developer level?

551


can u give example for factless fact table

5505


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1616


what is degenerated dimension?

3142






What are the reusable transformations?

692


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

630


What are the features of complex mapping?

639


What is informatica? Why do we need it?

628


How to call shell scripts from informatica?

570


Define update strategy?

631


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1744


Explain incremental aggregation in informatica

650


Separate from an archive server and a powerhouse?

487


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1843