Interested to Buy Any Domain ? << Click Here >> for more details...
In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure?
- 5 Answers
- 9801 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram
Create normaliser...
derive 2 ports
col_1 occurence=2
col_2 Occurence=2
now you will get four input ports..
col1 -->col_1
col1---> col_1
col2--->col_2
col3--->col_2
connect two output ports from normaliser to Target..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a code page?
How do you convert single row from source into three rows into target?
How can we delete duplicate rows from flat files?
What is a joiner transformation?
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
What is the use of code page?
What is informatica etl tool?
Repository user profiles
How to open an older version of an object in the workspace?
Clarify the aggregator change?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
To import the flat file definition into the designer where should the flat file be placed?
What is a grid in Informatica?
What do you mean by channel change?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
