Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  


when informatica 8 series released ?

1 Answers   IBM,


how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,


How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,


Repository user profiles

0 Answers  


What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,


hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,


why we use materialized view over view?

1 Answers   Zensar,


What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  


What are the different types of schemas?

11 Answers   ITC Infotech,


2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,


Categories