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
- 11740 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
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the static cache and dynamic cache in informatica?
How can we improve session performance in aggregator transformation?
What are mapplets?
What is the advantage of informatica?
What is meant by query override?
State the limitations where we cannot use joiner in the mapping pipeline?
What is data movement mode in Informatica and difference between them?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is parallel processing in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Mention some types of transformation?
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?
What is a transaction control transformation?
What is a connected transformation?
