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
- 11579 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / suri
thats a oracle answer
but in informatica u have to use reverse pivoiting
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How do you load only null records into target? Explain through mapping flow.
How do you load alternate records into different tables through mapping flow?
How to load last n records of file into target table - informatica
What is option by which we can run all the sessions in a batch simultaneously?
Explain informatica architecture - version 8 / 9
How would you join a node to the already existing domain?
What do you mean by blocking transformation?
What is sorter transformation?
design of staging area?
How can you define user defied event?
How to handle decimal places while importing a flatfile into informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the different ways to implement parallel processing in informatica?
