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 .?
- 5 Answers
- 16928 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
Explain sessions. Explain how batches are used to combine executions?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the features of complex mapping?
What does “tail –f” command do and what is its use as an Informatica admin.
What are roles and groups and benefits of using them?
How to load the data from people soft hrm to people soft erm using informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Differentiate between source qualifier and filter transformation?
Explain the pipeline partition with real time example?
What are the static cache and dynamic cache in informatica?
What is main use of mapplet?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain the types of transformations?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
