How will you update the first four rows and insert next
four rows in a mapping?
- 5 Answers
- 9804 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / srini
generate sequence number and use mod function in router t/r.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Name the different lookup cache(s)?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are the types of schemas we have in data warehouse and what are the difference between them?
Define filter transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the types of lookup transformation?
What is substr in informatica?
What are the reusable transformations?
How to extract sap data using informatica?
Under what condition selecting sorted input in aggregator may fail the session?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the informatica performance improvement tips
What are the prerequisite tasks to achieve the session partition?
