source
file name xyz
a,0,a,a,a
b,b,b,0,b
c,c,c,0,c
target should be like this
xyz
a
b
c
how to implement this?
Answer Posted / rajesh
use normalizer trans,then give condition input 5,output 1 as
accurs 5,resulting all columns in single column as manay as rows
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Slowly changing dimensions, types and where will you use them
Define enterprise data warehousing?
Where can we find the throughput option in informatica?
How to elaborate powercenter integration service?
How do you handle two sessions in Informatica
How you prepared reports for OLAP?
Enlist some properties of sessions.
Differentiate between source qualifier and filter transformation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the issues you have faced in your project? How did you overcome those issues?
Why filter transformation is an active one?
What is fact table? Explain the different kinds of facts.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
whats the logic to load the lower level of granularity of data to fact table.