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
- 5332 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can anyone tell me the new features in Informatica 9 Version?
What are the different options available for update strategy?
Explain about cumulative Sum or moving sum?
What are the different clients of powercenter?
Explain the etl program with few examples.
How to elaborate powercenter integration service?
How to extract the informatica rejected data?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is meant by incremental aggregation?
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.
Explain transaction control transformation in informatica
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
