Interested to Buy Any Domain ? << Click Here >> for more details...
Filter transformation in the condition one of the data is NULL would the record be dropped.
- 2 Answers
- 5463 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / isha
Use ISNULL function to guide filter to handle null values.
NULL will return 0 and row will be dropped
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sameer
Yes we write in filter conditions iif (isnull (cid),false,true) or using is_spaces function in there filter transformation and we can dropped the null records
| Is This Answer Correct ? | 0 Yes | 0 No |
how will you remove the duplicate records from flat file without using sorter?
connected and unconnected lookups?
What are the basic needs to join two sources in a source qualifier?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
Describe an informatica powercenter?
What do you mean incremental aggregation?
can u give example for factless fact table
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
What are differences between Informatica 7.1 and 6.1
Teradata 
