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
- 8091 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 |
where is the cache (lookup, index) created and how can you see it.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
Hi, Lookup() is what kind of join ?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
what is the difference between date cache and lindex cache?
what is the difference between cardinality and Nullability?
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
Need Informatica Power Center 9.1 free download(for all windows version)
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
what is the indicator file and where it is used?
Teradata 
