Interested to Buy Any Domain ? << Click Here >> for more details...
How to display null values on a target & non-null values on
a target?
- 3 Answers
- 9063 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
How to load a Dimension ? and how to load a fact table?
How to extract sap data using informatica? What is abap? What are idocs?
Global and Local shortcuts. Advantages.
What is a predefined event?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is an aggregator transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the command used to run a batch?
How do you load alternate records into different tables through mapping flow?
Clarify the utilization of aggregator cache record?
What is the format of informatica objects in a repository?
