How can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).
- 5 Answers
- 8560 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay
You can also use expression transformation. Write the logic
i = 0 and increment it in another column. Give this column
as output.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Have you worked with/created Parameter file
difference between repository database and repository service?
Define enterprise data warehousing?
Under which circumstances, informatica server creates reject files?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what is SDLC way of code development?
What are the uses of etl tools?
How to delete duplicate row using informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
What is a sorter transformation?
where to store informatica rejected data?
What is data caches/ index caches?
What is a surrogate key?
In how many ways we can create ports?
