Interested to Buy Any Domain ? << Click Here >> for more details...
Hi please try to reply with answer. my mail id is
raghu.1028@gmail.com.
if the source is having millions of records, but having
theree target tables. As per user the first record need to
insert into first target and second record in to a second
target and third into third target, similarly the process
needs to repeat?
- 5 Answers
- 8624 Views
- I also Faced
- E-Mail Answers
Answer Posted / siddiq
First U will create sequence number for the 3records
using sequence generator t/r then U can create an
expression t/r in that use the mod function like
mod(seqno,3)=1
mod(seqno,3)=2
mod(seqno,3)=0
then u will get the resulr
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
where is the cache (lookup, index) created and how can you see it.
what is the difference between cardinality and Nullability?
Can u access a repository created in previous version of Informatica?
What are the steps involved in etl process?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
what is dynamic insert?
what is session partitioning?
How many steps etl contains?
explain the methodology of Data Warehousing?(Polaries)
Explain etl mapping sheets?
Can we create Hierarchies in generic datasources?
What is abap? What are idocs?
what are the reporting tools and difference between them?
What are your responsibilities as an etl tester?
What are cubes and olap cubes?
