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
- 10206 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nithyanandan
use normaliser transformation for this question
ur source contain 3-column ,
wihile taking to target there is should not be primaty key
colum in ur target table.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / ankit kansal
It can be one of the solution
tgt table contains two columns
src->sq->exp1-->>tgt(1) one instance of tgt table.
---------exp2-->>tgt(2) second instance of tgt table.
*after sq forward c1 and c2 to exp1
and c1 and c3 to exp2
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / k gopi krishna
1. Define source
2. Define SQF
3. put union stage
in first group put col1 and col3
in 2nd group put col2 and col3
4 link it to output file
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
Answer / roopanwita
There is a stage in Datastage,Pivot to do normalization.
| Is This Answer Correct ? | 0 Yes | 2 No |
What is mapplet in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How we can create indexes after completing the load process?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
How to use pmcmd utility command?
How will the document be delivered to me?
What are the connected or unconnected transforamations?
how do u move the code from development to production?
how to we create datamart?
Explain lookup transformation in informatica
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
Teradata 
