when we use dynamic lookup,if condition matches what will be
the o/p?
Answers were Sorted based on User's Feedback
Answer / sujana
it updates the row in the cache r leaves it unchanged
| Is This Answer Correct ? | 12 Yes | 0 No |
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
what is normalization? explain 1st NF, 2nd NF, 3rd NF
where does the default group roew in a router is stored what is the default size of memory in router
How do you handle two sessions in Informatica
What are the new features of the server manager in the informatica 5.0?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
in static and dynamic which one is better
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
Write the advantages of partitioning a session?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?