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
- 11790 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 a joiner transformation?
what is degenerated dimension?
How are indexes created after completing the load process?
What are the different types of olap? Give an example?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Global and Local shortcuts. Advantages.
Sequence generator, when you move from develoment to production how will you reset
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Plz can any one say me how to get the informatica certification materials and dumps
Explian the Process of deployment groups in informatica
What is an aggregator transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is an unconnected transformation?
What are the new features of informatica 9.x developer?
