How to display null values on a target & non-null values on
a target?

Answer Posted / infa

using iif and isnull functions in expression

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where are the source flat files kept before running the session?

821


What are the databases that informatica can connect to windows?

784


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

1952


What is the difference between Active and Passive transformation?

838


tell me 5 session failure in real time how can you solve that in your project?

1862






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

1816


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?

5963


How to generate sequence numbers using expression transformation?

812


explain abt ur project architecture?

1905


What is meant by a domain?

829


What are the tasks that can be performed using sq?

800


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

807


Implementation methodology

1460


What does reusable transformation mean?

848


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

1937