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
- 10196 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 the size of ur database(like oracle)
Can i create a lookup table without cache.
what is diffrence b/w joner and union transfermation
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
How might you approve all mappings in the archive all the while?
Why is meant by direct and indirect loading options in sessions?
what is the method of error handling when session is running?
If informatica has its scheduler why using third party scheduler?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
Teradata 
