use decode function in Expression taking one new column as Flag ii

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT
APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

Question Posted / praveen kumar pendekanti

Answer Posted / praveen kumar pendekanti

use

decode function in Expression taking one new column as Flag

iif is_null(column_name,-NA-,column_name)

Is This Answer Correct ?

14 Yes

1 No

Please Help Members By Posting Answers For Below Questions

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1627

how tokens will generate?

2152

How you can differentiate between connected lookup and unconnected lookup?

1003

Mention some types of transformation?

988

Explain the pipeline partition with real time example?

1080

Describe the impact of several join conditions and join order in a joiner transformation?

1006

What is Cognos script editor?

4157

Target increases every day even though no new record was inserted

1513

how to load dimension table and fact table. plz tell me the steps.

2034

What is session task and command task?

1172

Explain lookup transformation is active in informatica

1030

What is a repository? And how to add it in an informatica client?

1080

What is meant by lookup transformation?

1032

What is the use of transformation?

944

In informatics server which files are created during the session rums?

1060