Interested to Buy Any Domain ? << Click Here >> for more details...
I have one source table and three target tables.
When the session runs for the first time involving the
mapping,i want that the loading should take place in 1st
Target table only.
The 2nd time the same session runs the loading should take
place in 2nd Target only only
and similarly when the session runs for the 3rd time loading
should take place in Third only.
And again when the session runs for the 4th time loading
should take place in 1st Target table.
- 4 Answers
- 13154 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / bhupal
Hi all,
Use sequence generator to generate the sequence.
properties should be
start value=1
end value=3
check the cycle option.
connect this nextvalue port to router and make there groups.
group_1----> nextvalue=1
group_2----> nextvalue=2
group_3----> nextvalue=3
connect first group to first target and second group to second target and then third to third.
flow will be like this
sequence generator
|
source---->source qualifier---->router--------Target 1
|-----------Target 2
|-----------Target 3
please let me know if you have any new questions.
mail id: bhupalreddy200@gmail.com
| Is This Answer Correct ? | 1 Yes | 20 No |
Post New Answer View All Answers
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Write the unconnected lookup syntax?
What is the difference between source qualifier transformations source filter to filter transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
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?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is a transaction control transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Make a note of the quantity vaults made in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Describe data concatenation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Partition, what happens if the specified key range is shorter and longer
