Interested to Buy Any Domain ? << Click Here >> for more details...
Whether Aggrigator transformation ignore the null values or
consider the null values ?
Advance Thanks,
Manojkumar
- 3 Answers
- 8994 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jey.dgl
Yes. Aggregator transformation ignore the null values and In Oracle also ignore the null values.
If u want to ignore the null values, use isnull() function to avoid null values
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is dimensional table?
How you can differentiate between connected lookup and unconnected lookup?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
how to load dimension table and fact table. plz tell me the steps.
Parameter and variable differences
Design a mapping to load the cumulative sum of salaries of employees into target table?
Different sorts of metadata that stores in the storage facility?
What is a grid in Informatica?
What is fact table? Explain the different kinds of facts.
design of staging area?
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
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How can you define user defied event?
Performance tuning( what you did in performance tuning)
What is the use of an aggregator cache file?
