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

Answer Posted / abidu

Write 'not applicable' as the default in the expression
transformation.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Scheduling properties,whats the default (sequential)

1456


What are mapplets?

812


What the difference is between a database, a data warehouse and a data mart?

588


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

618


What are the modules in Power Center

1221






Clarify the aggregator change?

589


What is joiner transformation in informatica?

623


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1838


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1575


What is incremental aggregation?

570


what is Active lock explain

2363


What are the different clients of powercenter?

592


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6455


What is informatica? Why do we need it?

628


What are the tasks that can be performed using sq?

603