Interested to Buy Any Domain ? << Click Here >> for more details...
Explain one complecated mapping?
- 3 Answers
- 14959 Views
- Fidelity, Wipro, I also Faced
- E-Mail Answers
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 |
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
what is the size of your data warehousing?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
What are differences between Informatica 7.1 and 6.1
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
Explain sessions?
Roles and Responsibilties of Informatica Production Support Member?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
Teradata 
