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 |
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
How can you generate reports in informatica?
Explain what is informatica metadata and where is it stored?
how to load only the first and last record of a flat file into the target?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
can a port in expression transf be given the name DISTINCT
How to load a Dimension ? and how to load a fact table?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a pre-defined event and user-defined event?
How Union Transformation is an Active Trans?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?