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

5 Answers
16572 Views
HP, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the settings that you use to configure the joiner transformation?

1010

Is there any way to read the ms excel datas directly into informatica?

986

How can we handle two sessions in informatica?

991

Differences between version 7.x and 8.x.

1852

Is it possible to define a single node as a Gateway node as well as worker node?

1071

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1453

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1983

What is meant by target load plan?

925

Can u generate reports in Informatica?

1035

Enlist the differences between database and data warehouse.

1050

Differentiate between a repository server and a powerhouse?

1058

What is a connected transformation?

1061

Mention some types of transformation?

1002

How to load a Dimension ? and how to load a fact table?

1378

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1995