Interested to Buy Any Domain ? << Click Here >> for more details...
how can u generate sequence of values in which target has
more than 2billion of records.(but with sequence generator
u can generate upto 2 biliion only)
- 6 Answers
- 20421 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / chinna
by using unconnected lookup transformation u can check
condtion ie counter >0 it will be allways true,
or you can use oracle sequence or stored procedure
u have any querries revert me on chinnadw@yahoo.com
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
what is INFORMATICA TESTING process
How to update or delete the rows in a target, which do not have key fields?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is meant by pre and post session shell command?
What is the difference between informatica 7.0 and 8.0?
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.
How we can create indexes after completing the load process?
What all are steps in up gradation of Informatica server?
What is workflow manager?
How to create a non-reusable instance of reusable transformations?
What are the types of schemas we have in data warehouse.
What is the way to execute pl/sql script using informatica mapping?
How many ways a relational source definition can be updated and what are they?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
what is degenerated dimension?
