Whether Aggrigator transformation ignore the null values or
consider the null values ?

Advance Thanks,
Manojkumar

Answer Posted / ankur saini er.ankur861@gmail.

yes aggregator ignore null values but joined consider
them...

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1913


How can we improve session performance in aggregator transformation?

908


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2369


What all join we can perform in LOOKUP transformation?

768


Enterprise data warehouse your projects phase by phase explain?

1688


What are the reusable transformations?

917


What does role playing dimension mean?

827


What is the difference between a repository server and a powerhouse?

1183


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1943


How to convert multiple rows to single row (multiple columns) in informatica

1150


What are the transformations that are not supported in mapplet?

802


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

843


Explain the code page compatibility?

856


Briefly describe lookup transformation?

813


How union transformation is used?

803