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?
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
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
what is data modeling?
can be used COM component in Informatica ?
where is the cache (lookup, index) created and how can you see it.
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Identifying the bottlenecks in various components of Informatica and resolving them.
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
what are Lookup caches options? Including persistent caches.
dimension object created in oracle can be imported in designer?how?
What are the key benefits of ETL Testing?
Explain different types of partitioning?
Define slowly changing dimensions (SCD)?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
how do u identify the changed records in operational data?