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 |
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
How informatica recognizes mapping?
what are the settiings that u use to cofigure the joiner transformation?
Briefly describe lookup transformation?
Design a mapping to load a target table with the following values from the above source?
What are the transformations that are not supported in mapplet?
How to handle decimal places while importing a flatfile into informatica?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
What is critical mapping?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
Write the program through which the records can be updated?