Interested to Buy Any Domain ? << Click Here >> for more details...
I am hvaing SOURCE as
1000,null,null,null
null,2000,null,null
null,null,3000,null
null,null,null,4000
Now i want the OUTPUT as
1000,2000,3000,4000
For more clarification i want to elimate nulls and want in
a single line.
Please help me out
- 5 Answers
- 9873 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / madhavi
In the lookup transformation->properties->presql condtion
write delete from table_name where column_name="NULL";.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
In warehouses how many schemas are there?
What all are steps in up gradation of Informatica server?
What do mean by local and global repository?
What is target load order?
How to load last n records of file into target table - informatica
Explain the mapping variable usage example in informatica
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
what is the size of your data warehousing?
What is persistent lookup cache?
What are the advantages of informatica?
Explain the different dimensions.
How many transformations can be used in mapplets.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain your project of banking domian.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
