Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

what is the size of your data warehousing?

0 Answers   IBM,

What is A cache?

2 Answers  

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

Why do we use DSS database for OLAP tools?

2 Answers  

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

What is the difference between a repository server and a powerhouse?

0 Answers  

How/where can i install Informatica software with oracle or teradata as database

0 Answers  

For more Informatica Interview Questions Click Here
Categories