Few Tricky Informatica Questions !!

[drp2005]

Please answer these questions. I would appreciate your answers.

1. How do you write any query on Informatica Repository

2. How do you use lookup without cache ?

3. I have five different sets with unique field timestamp. I need only one record out of five.
How do i write delete statememnt using Simple SQL.

Input

1 abc timestamp1
1 abc timestamp2
1 abc timestamp3
1 abc timestamp4
1 abc timestamp5

output

1 abc timestamp5


4. I have input like this

a b c d e

I need output like this but I don't want to use Normalizer to solve this. What is the other
alternative in Informatica ?

a
b
c
d
e

5. How do you use reusable session in the workflow ?

6. How does persistent cache work in behind ?

7. Why do you use stored procedure and why not informatica ?

8. How do you use log files with debugger ?

9. Have you created surroagate keys from dynamic cache?

10. How do you calculate something using lookup ?

Thank you,
drp2005

 

[ArtieChoke]

This is an April fool's joke, right?!!!

Most of these are non-sensical - like:
10. How do you calculate something using lookup ?

a lookup is a lookup - you can't do calculations in it.

going on a job interview?

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[blom0344]

It's the 25th of April, so we'll consider this a waste of space. Go study ...

Ties Blom
Information analyst