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
- 11571 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
Why union transformation is an active transformation?
How to Create a folder using pmrep command?
In development project what is the process to follow for an etl developer from day1
What is an aggregator transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How many ways are there to do 'remove duplicate records in informatica'?
Is it possible to create multiple domains on a single Informatica server?
How can we handle two sessions in informatica?
How to create Target definition for flat files?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the new features of informatica 9.x in developer level?
how many types of dimensions are available in informatica?
Explain the types of lookup transformation?
How do you load only null records into target? Explain through mapping flow.
