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?
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 |
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
how to obtain performance data for individual transformations.
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
What is Java Transformation? what are the uses of it?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
What are the main issues while working with flat files as source and as targets ?
in which situations do u go for sequence generator ?
What is dimensional table? Explain the different dimensions.
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
Whats the difference between $, $$, $$$