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 |
What is difference between a connected look up and unconnected look up?
How you load distinct records into one target and duplicate records into another target?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
How the informatica server sorts the string values in Rank transformation?
Explain transaction control transformation in informatica
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
which is better perfomancewise lookup or joiner and why?can anyone give example?
What r the type of indexes u generally used in informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
What exactly mentioned in High level design document.can somebody explain me sequentialy.