| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| wt is Dynamic lookup Transformation?
when we use?how we use?
| | 2 |
| What are the diffrences between joiner transformation and
source qualifier transformation? | | 2 |
| What are the join types in joiner transformation? | | 1 |
| What is the target load order? | | 2 |
| how to run two workflow(not a sessions) sequentially, what
is the process. Plz explain detailed information. | Keane-India-Ltd | 3 |
| 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)
| iFlex | 2 |
| surrogate keys usage in Oracle and Informatica? | Oracle | 3 |
| wat s mapping parameter and mapping variable? how do you
set that in a mapping? | | 2 |
| wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i. | CTS | 1 |
| What is batch and describe about types of batches? | | 1 |
| What is status code? | | 1 |
| What are the types of lookup? | Wipro | 3 |
| how to run 2 workflows sequentially. plz respond what is the
process? | Cap-Gemini | 2 |
| I've an excel sheet, in which one column contains data about
the location like "City, State" and few columns contains
only "State". Now I wanna load into my target City and State
into two different columns. Pls help me out... | | 5 |
| hw cn v elimate dublicate values from lookup without
overriding sql? | CTS | 6 |
| Which kind of index is preferred in DWH? | | 2 |
| I'd like the load to be triggered by client. By placement
of a file or somehow. How is it done in Informatica? I'm
using version 7.1.4
This is so urgent - I really appreciate your help :-) | ECI-Telecom | 2 |
| What is IQD file?
| | 1 |
| when i was running the seesion, after loading 100 records,
session suddenly fails.Next time i want to load the remaing
rows in target with out truncate target table.What should i
use? | TCS | 3 |
| In a mapping i have three dimensions. If i want to pass a
same surrogate key value to all the three dimensions by
using one sequence generator is possible?If the mapping is
containing single flow? And in the same case if the mapping
is contaning 3 flows for the three dimensions then by using
one sequence generator can we populate surrogate key (same
value) to all the three dimensions? | | 6 |
| |
| For more Informatica Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
