Describe two levels in which update strategy transformation
sets?
Answer / swetha
Within a session. When you configure a session, you can
instruct the Informatica Server to either treat all records
in the same way (for example, treat all records as inserts),
or use instructions coded into the session mapping to flag
records for different database operations.
Within a mapping. Within a mapping, you use the Update
Strategy transformation to flag records
| Is This Answer Correct ? | 7 Yes | 2 No |
tell me the push down optimization
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
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.
hw cn v elimate dublicate values from lookup without overriding sql?
What are the different tools in workflow manager?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
What are parallel querys and query hints?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
Why we use lookup transformations?
What are the different ways to implement parallel processing in informatica?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).