Interested to Buy Any Domain ? << Click Here >> for more details...
I am having a FLAT FILE SOURCE as first line:
1000,null,null,null
second line as:null,2000,null,null 3rd line
as :null,null,3000,null and final line as:
null,null,null,4000 ............................Now i want
the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For
more clarification i
want to elimate nulls and want in a single line. Please
help me out
- 5 Answers
- 11985 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jayesh
Filter in source qualifire itself..in sq query or sq filter.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is the need of an ETL tool?
What are the restrictions of union transformation?
What is the session task and command task?
What is rank transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain the difference between a data warehouse and a data mart?
Make a note of the quantity vaults made in informatica?
can we override a native sql query within informatica? How do we do it?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Can we create a Integration service without a Repository service and vice versa?
What are the various types of transformation?
Explain what is informatica metadata and where is it stored?
Is there any target staging area in informatica not staging area
Explain what transformation and how many are there in informatica?
How to extract sap data using informatica? What is abap? What are idocs?
