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 |
what is scd?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
What is a unit Testing?
Differentiate between a repository server and a powerhouse?
what is the difference between repository & Intergration service
how to sort date field in infomatica?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
Performance wise which is better joiner or look up ? Give me with example?