How to display null values on a target & non-null values on
a target?
- 3 Answers
- 7836 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramesh.b
hi,
normally router means multiple targets...take 2 groups first group condition isnull and second group condition not isnull.first group gives the null values and second group gives the non null values.
source-->sq-->expression-->router-->2 targets
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is target load order?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is workflow? What are the components of workflow manager?
Mention few advantages of router transformation over filter transformation.
Implementation methodology
What is the need for an etl tool?
Explain target update override in informatica
Enlist few areas or real-time situations where informatica is required.
Is there any target staging area in informatica not staging area
What is powercenter on grid?
What does cheating measurement mean?
Performance tuning in UNIX for informatica mappings?
Explain the features of connected and unconnected lookup.
design of staging area?
