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 |
In update strategy target table or flat file which gives more performance ? why?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
If you want to create indexes after the load process which transformation you choose?
Reusable transformation and shortcut differences
What is the commit type if you have a transaction control transformation in the mapping?
which transformation uses cache?
When do you use mapping parameters? (In which transformations)
How to differentiate between the active and passive transformations?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Explain the mapping variable usage example in informatica
What is the Rankindex in Ranktransformation?