In the column properties sheet, write N/A in the Default value text box f

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

Question Posted / sri ram

Answer Posted / sri ram

In the column properties sheet, write N/A in the Default
value text box for the particular column

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Describe data concatenation?

1082

Briefly define reusable transformation?

1131

Can we change Dynamic to Static or Persistent cache? If so what happens?

2210

Performance tuning( what you did in performance tuning)

1988

What is the difference between informatics 7x and 8x and what is latest version?

1085

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1058

Explain direct and indirect flat file loading (source file type) - informatica

1318

Differentiate between router and filter transformation?

1012

What is an expression transformation in informatica?

1039

What is workflow manager?

1049

Why update strategy and union transformations are active? Explain with examples.

1240

When do you use sql override in a lookup transformation?

1099

without table how to come first record only in oracle?

2255

How can you validate all mappings in the repository simultaneously?

1371

Enterprise data warehouse your projects phase by phase explain?

1921