i have 1000 records in my dource table, the same i have in
target ,but a new column added in target as "batchno", and
this column adds no 10 for 1st 100 records and 20 for next
100 records and 30 next 100 records and vice versa. how to
acheive this?
- 6 Answers
- 10045 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / srikanth
target update over ride..
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is degenerated dimension?
What is confirmed fact in dataware housing?
How to handle decimal places while importing a flatfile into informatica?
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 main use of mapplet?
What is mapplet in informatica?
What is DR strategy for Informatica project?
Explain what are the different versions of informatica?
How do you migrate data from one environment to another?
can u any challenge your project?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a surrogate key?
Differentiate between reusable transformation and mapplet.
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 is the use of target designer?
