1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / guest

Answers were Sorted based on User's Feedback



In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, co..

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

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, co..

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

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, co..

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

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, co..

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

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, co..

Answer / roopanwita

There is a stage in Datastage,Pivot to do normalization.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

tell me the rules and responsblites in our project(my project is development)

0 Answers  

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

what are cost based and rule based approaches and what is the difference?

1 Answers  




What is source qualifier transformation in informatica?

0 Answers  

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

What is the benefit of session partitioning?

0 Answers  

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

why do u use shortcuts in informatica.?

4 Answers   iFlex,

Can you copy the session to a different folder or repository?

2 Answers  

For more Informatica Interview Questions Click Here
Categories