Explain one complecated mapping?

Question Posted / guest

3 Answers
15121 Views
Fidelity, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain one complecated mapping? ..

Answer / rao

normalizer transformation.which will performs normalized data.
ex:year q1 q2 q3
2006 10 20 30
2007 20 30 40
after performing the normalizer transformation the date
will be like this
year item sales
2006 1 10
2006 2 20
2006 3 30
like 2007 also

Is This Answer Correct ?

1 Yes

1 No

Explain one complecated mapping? ..

Answer / informatica_learner

upstare,Rao
this only use one nomalizer transformation
configure one item as occurs 3 is ok
it is easy

Is This Answer Correct ?

0 Yes

0 No

Explain one complecated mapping? ..

Answer / ram kumar

SCD 2 is one of the complecated mapping in informatica

Is This Answer Correct ?

3 Yes

5 No

Post New Answer

More Informatica Interview Questions

explain about session partitions ?

1 Answers

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers Cap Gemini,

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers

Explian the connected and unconnected lookup transformation

1 Answers Informatica,

What is status code?

2 Answers

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers Patni,

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers Puma,

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers IBM, TCS,

what is the look up transformation?

2 Answers Informatica,

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers

what is the flat file partition and where have to specify it

1 Answers TCS,

For more Informatica Interview Questions Click Here