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
- 11987 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / srinivas
dataflow
FF-----> Sourcequalifier...>aggregatore T/F....>target
in aggregator transformation add three new ports
o_col1,0_col2,o_col2 and make output ports
and expression in out ports
o_col1-----MAX(col1),
o_col2-----Max(col2),
o_col3-----Max(col3);
and connect these output ports to target
you will get the resul
| Is This Answer Correct ? | 13 Yes | 8 No |
Post New Answer View All Answers
Write the unconnected lookup syntax and how to return more than one column.
What do you understand by a term domain?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
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 ?
What is aggregator transformation in informatica?
Explain sessions. Explain how batches are used to combine executions?
can you please explain me pre session and post session options?
What is an active transformation?
How you prepared reports for OLAP?
What is sorter transformation?
What are the transformations that are not supported in mapplet?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
update strategy transformation in informatica
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
