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
- 20924 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 the Rank index port in Rank transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How do you load only null records into target? Explain through mapping flow.
Informatica settings are available in which file?
What is data transformation manager process?
What is aggregate cache in aggregator transformation?
How to update source definition?
How to do the error handling of if ur source is flatfiles?
Enlist the tasks for which source qualifier transformation is used.
EXL informatica Questions
differences between service based and product based?
What are pre and post-session shell commands?
Explain pushdown optimization $pushdownconfig parameter - informatica
can u give example for factless fact table
