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
- 11738 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 is the difference between stop and abort in informatica
To import the flat file definition into the designer where should the flat file be placed?
which one is better performance wise joiner or look up
Briefly define reusable transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How to Create a folder using pmrep command?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain what are the different versions of informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Under what condition selecting sorted input in aggregator may fail the session?
Separate from a database, an information bazaar, and an information stockroom?
In informatica workflow manager, how many repositories can be created?
Differentiate between sessions and batches?
Plz can any one say me how to get the informatica certification materials and dumps
Explain transaction control transformation in informatica
