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
How union transformation is used?
What is InformaticaPowerCenter?
What are the different clients of powercenter?
What are the uses of etl tools?
What happens when a session fails and you click on recover?
Different qualification between a related rotate toward the sky and isolates look upward?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the differences between oltp and olap?
Differentiate between router and filter transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
design of staging area?
I have a flat file, want to reverse the contents of the flat file
waht type of interface is used for testing the data in informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?