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
- 14966 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
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different transaction levels available in transaction control transformation?
What is Session and Batches?
can we override a native sql query within informatica? Where do we do it?
How do you handle two sessions in Informatica
How we can use union transformation?
How can we use mapping variables in informatica? Where do we use them?
Design time, run time. If you don't create parameter what will happen
How to update or delete the rows in a target, which do not have key fields?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How do you load only null records into target? Explain through mapping flow.
Briefly describe lookup transformation?
Mention a few design and development best practices for informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
