if we r using aggregator we enabled sorted input but the
records r not sorted what happen?

Answer Posted / k gopi krishna

Session throws warning. can see it in log file
In case of Join , i guess session fails

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Suppose we do not group by on any ports of the aggregator what will be the output?

848


How can informatica be used for an organization?

934


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5759


What is the benefit of session partitioning?

860


What is a node in Informatica?

850


What are the different types of transformation available in informatica.

862


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1415


What is the difference between source qualifier transformations source filter to filter transformation?

876


How do we call shell scripts from informatica?

815


Explain what is informatica metadata and where is it stored?

859


Whats the difference between informatica powercenter server, repositoryserver and repository?

961


How to delete duplicate row using informatica?

834


How we can create indexes after completing the loan process?

1006


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3839


Differences between connected and unconnected lookup?

911