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.
Answer Posted / hai
there is an option to set the value as zero ,with out set
the value manually .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How might you approve all mappings in the archive all the while?
How do you set a varible in incremental aggregation
Differentiate between source qualifier and filter transformation?
What are multi-group transformations?
During the running session, output files are created by informatica server. Enlist few of them.
How to load last n records of file into target table - informatica
What is rank transformation?
explain one complex mapping with logic? sales project?
what is index?how it can work in informatica
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
have u done any performance tuning? how u ll do?
what is informatica metadata?
what is the hint? how to use it to reduce the query processing in program?