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
- 8888 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / murugan
normally router means multiple targets...first taget display
the null valuesw and another records display the non null
values..
| Is This Answer Correct ? | 3 Yes | 1 No |
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
What is the difference between STOP and ABORT options in Workflow Monitor?
How can a transformation be made reusable?
If you want to create indexes after the load process which transformation you choose?
What is polling in informatica ?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
What are the new features of informatica 7.1?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
what is the diff b/w target load plan and cbl?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
How can we handle two sessions in informatica?
Teradata 
