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

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

Differences between connected and unconnected lookup?

0 Answers  

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

In dimension and fact table? which one holds big data?

2 Answers  

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

Explain grouped cross tab?

1 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories