Interested to Buy Any Domain ? << Click Here >> for more details...
Create a mapping which contains 2 target tables. When the
session runs for the first time it shud load Target table 1
and when it runs for second time it shud load Target
table 2.
- 7 Answers
- 15012 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / triveni munnangi
source_>sq->expression->router->tg1
->tg2
expression:v_count decimal 10 0(variableport) setvariable($$cnt,1)
o_count decimal 10 0 (outputport) $$cnt
router:groups
t1=o_count=0
0_count=1
$$cnt variable integer 10 0 max false
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we remove the duplicates from flat file source?
How many number of sessions can one group in batches?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How will the document be delivered to me?
What is DR strategy for Informatica project?
What are roles and groups and benefits of using them?
How do you promote a non-reusable transformation to reusable transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is meant by target load plan?
What is the reusable transformation?
What is meant by LDAP users?
What is the difference between stop and abort in informatica
explan ur project architecture?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
