Interested to Buy Any Domain ? << Click Here >> for more details...
Hello Everyone,i have one question on sequence generator.i
have two targets and the records comes from the source will
place in the targets like 1-10 rec in target1 and 11-20 rec
in target2,21-30 rec in target1...etc so any one can help
me? plz..Thanq in adv.
- 7 Answers
- 15517 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answer Posted / santosh_dw
It will work without making sequence generator cyclic
select mod(floor(3/10),2) from dual;
Ans: 0
select mod(floor(12/10),2) from dual;
Ans: 1
select mod(floor(25/10),2) from dual;
Ans: 0
select mod(floor(35/10),2) from dual;
Ans: 1
Thanks,
Santosh.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different components of powercenter?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
whats the logic to load the lower level of granularity of data to fact table.
What is the difference between a repository server and a powerhouse?
What is meant by pre and post session shell command?
How can we remove the duplicates from flat file source?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Is it possible to use a client with different version than that of its Informatica server?
What do you mean by enterprise data warehousing?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain the informatica workflow?
What is a standalone command task?
Explain direct and indirect flat file loading (source file type) - informatica
Explain in detail scd type 2 through mapping.
