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
- 16938 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / abidu
Write 'not applicable' as the default in the expression
transformation.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / yaseen
with the help of ISNULL() function of the Informatica...
| Is This Answer Correct ? | 1 Yes | 4 No |
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 |
What is DTM process?
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
Which files are created during the session rums by informatics server?
HOW TO GET THE LATEST DATA IN SCD ?
What are roles and groups and benefits of using them?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
What is native users?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Clarify the aggregator change?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
What are the types of schemas we have in data warehouse and what are the difference between them?
Teradata 
