Interested to Buy Any Domain ? << Click Here >> for more details...
without dynamic lookup transformation how to insert new
rows and update existing rows?
- 7 Answers
- 16576 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / bj
With out lookup and update st. transformation we can still
insert new and update data at session level.
in session at the time giving target table connect bottom u
find insert and update just check that box.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the different versions of informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is meant by query override?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
how to load rows into fact table in data warehouse
How to improve the performance of a session using sorter transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Sequence generator, when you move from develoment to production how will you reset
what is degenerated dimension?
How do you migrate data from one environment to another?
What is the meaning of up gradation of repository?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is aggregate cache in aggregator transformation?
Enlist the various types of transformations.
design of staging area?
