1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / ranjan

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / 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

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

Answer / abidu

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

Is This Answer Correct ?    1 Yes 1 No

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

Answer / yaseen

with the help of ISNULL() function of the Informatica...

Is This Answer Correct ?    1 Yes 4 No

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

Answer / bsgsr

hi, praveen

gud afternoon,
cool ans and clear explanation.
i am srinivas trying for a break on informatica.
i love xchange of knowledge to nrich further.
my mail id: bsgsr12@gmail.com
mail me if interested.

bye,
srinivas

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

How many ways are there to create ports?

0 Answers   Informatica,

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

Can we use parameters of parameter file in presession command

1 Answers   Wipro,




Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

How the Informatica Server reads perameter file?

1 Answers  

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

What is source qualifier?

6 Answers   SDS,

For more Informatica Interview Questions Click Here
Categories