Had any one faced informatica(ETL/Developer),
Datawarehouseing interview in UK.
Than plz help me (i have any exprience of 3yrs
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
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,
|Is This Answer Correct ?||8 Yes||0 No|
Answer / luicy
best of luck
|Is This Answer Correct ?||4 Yes||1 No|
have you developed documents in your project? and what documents we develop in realtime?
how we can load rejected record's at run time?(not through bad files)
What are the new features in Informatica 5.0?
All active transformations r passive or not?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
What are the informatica performance improvement tips
Suppose we do not group by on any ports of the aggregator what will be the output?
Differnce between filter and router?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
What is the difference between Normal load and Bulk load?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
How do you convert single row from source into three rows into target?