Interested to Buy Any Domain ? << Click Here >> for more details...
we have 1 source table containing 100 records. now we have
to transfer first set of 1-10 (i.e1-10) records to one
target table and another set of 1-10(11-20) records to
other target table and continue like that till 100th record
- 3 Answers
- 9031 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / zslstar
we can use the sql below to indicate the rownum.
then router the data according to the rownum from upstream.
select t.*,rownum rn from test t
where mod(floor(t.rn/10),2) =0 --get the rows whose rownum
between 1~9,20~29,etc.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / swetha
we can use sequence generator with cycle for that
| Is This Answer Correct ? | 4 Yes | 3 No |
Use seq. Generator to create sequence or you can use expression transformation to create sequence, then in router transformation create 10 group and give conditions like seq >1 and seq <11, seq>11 and seq <20 etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks
What is the difference between Data Warehousing and Data Mining?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
In Which Transformation We Can Use Having Clause In Informatica?
how do u implement unconn.stored proc. in a mapping?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
when should one create lookup transformation ?
what are variable ports and list two situations when they can be used?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what is SMP AND MPP?
Teradata 
