Interested to Buy Any Domain ? << Click Here >> for more details...
Hi experts ,I have a Source of 1000 records.I have to load
100 records in first target,101 to 200 records in 2nd
target, 201 to 300 records in 3rd target and again 301 to
400 in first target like that as cyclick process. How can i
acheive this.
- 5 Answers
- 13228 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answer Posted / ajay konidena
1st answeris correct but for this logic we do use number
of ' or ' operater and code becom big so thire is on
solution that in sequence genarater t/f thire is one
option that cyclic as in oracle sql .
by using this option and router we can do this
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Where do we use mapping variables in informatica?
What is the difference between informatics 7x and 8x and what is latest version?
What is joiner transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
tell me 5 session failure in real time how can you solve that in your project?
What are the different types of transformation available in informatica.
what is the complex transformation you used in informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the use of source qualifier?
How can you differentiate between powercenter and power map?
What is the use of code page?
How do you load first and last records into target table?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
