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 can we delete duplicate rows from flat files?

1 Answers  

Briefly describe lookup transformation?

1 Answers  

Difference Between ETL & ELT?

1 Answers   TCS,

Name the different lookup cache(s)?

1 Answers  

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers   Wipro,

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  

For more Informatica Interview Questions Click Here
Categories