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
- 15251 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
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is different between the data warehouse and data mart?
Explain the different kinds of facts.
What is a difference between complete, stop and abort?
During the running session, output files are created by informatica server. Enlist few of them.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Describe an informatica powercenter?
what is the hint? how to use it to reduce the query processing in program?
What is persistent lookup cache?
Explain about cumulative Sum or moving sum?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is fact table? Explain the different kinds of facts.
What do you mean by worklet?
What is dynamic cache?
Differences between version 7.x and 8.x.
