Explain one complecated mapping?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / ram kumar
SCD 2 is one of the complecated mapping in informatica
| Is This Answer Correct ? | 3 Yes | 5 No |
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
how will you remove the duplicate records from flat file without using sorter?
What is the meaning of decode in informatica?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
Can anyone tell me the new features in Informatica 9 Version?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
What are the data movement modes in informatcia?
What is data movement mode in Informatica and difference between them?
Why sorter is an active transformation?
If u r using dynamic cache lookup port will be thier in thet which option u will select
How do you load unique records into one target table and duplicate records into a different target table?