Interview Questions 1

[onebyone]

Hi
I just attended an Interview for Informatica Developer.

Two of the questions they had asked me which i didnt know were.

1.Have you used shell scripts as an Informatica ETL developer.If so where and why?
2.Which is the most complex transformation have you done so far?

I would appreciate you answers to the above questions.

 

[walkerci]

Regarding question number 1 - you can use shell scripts to drop and create indexes via dbms utilties, invoke an OS utility to pre-process a file (grep, awk, etc), etc, etc.

Regarding question number 2 - only you can answer this.

Good luck,

Charles

 

[Dagon]

It sounds to me as if you did know the answers i.e. you hadn't used shell scripts and you hadn't done anything particularly complicated with Informatica.

 

[blom0344]

You may wonder if the interviewer knew his business with the second question. Sure you will have to get complex problems to solve using informatica, but the whole idea of using different type of transformations is to tackle complex stuff in steps. If your mapping solves the extraction with acceptable performance you can regard it as a succesful one. There is no bonus in getting the job done with minimal set of transformations. In extreme cases you may want to split the problem over more than one mapping , using temp tables as intermediates if that does it....

T. Blom
Information analyst
tbl@shimano-eu.com