Sign Up Login


  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

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

What is hash partition?

2 Answers  

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

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.

6 Answers   Accenture,

How to Create a folder using pmrep command?

0 Answers  




what is mapping parameter?

2 Answers   Cap Gemini,

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

What are Rapid changing dimensions?

1 Answers  

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

what type of transformation is not supported by mapplets?

4 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories