Had any one faced informatica(ETL/Developer),
Datawarehouseing interview in UK.
Than plz help me (i have any exprience of 3yrs
informatica,datawarehousing,oracle,teradata)
1.hw the procedure will b here
2. wht type of question's they will b asking.
3.In which area they concertate more.
since this is the first time im facing interview in UK.
plz help ASAP.it will b a great help for me
thanks to All in Advance
Answers were Sorted based on User's Feedback
Answer / bsgsr
hi, dude
ur question is quite strange and interesting.
i can understand but to tell you informatica subject is
functionality is same across the globe. So the interview
would be the same. i mean the technical questions depends
on your projects and your listed responsibilities as well
any knowledge of other dwh tools too to some extent.
Also,the technical toughness depends on the interviewer
mood and your fateeeeeeeeeeeeeeee 222222222222222222222.
gud luck dude anyways,
bsgsr12@gmail.com
| Is This Answer Correct ? | 8 Yes | 0 No |
tell me 7.x and 8.x diferrencess(but not transformations)
What is souce qualifier transformation it is active or passive
what is the complex transformation you used in informatica
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
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 are factless facts? And in which scenario will you use such kinds of fact tables.
What is the difference between Bulk Load and Normal Load
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Explain direct and indirect flat file loading (source file type) - informatica
Can you access a repository created in previous version of Informatica?
how many ways can we implement SCD2?