In mapping f.f as one src and f.f as trg,f.f as src and
oracle as trg which is fast? mean which is complete first
process
Answers were Sorted based on User's Feedback
Answer / sai krishna karri
ff as source and ff as target, this will be the faster
process. Because writing to the flatfile is faster than
writing it into a database.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / ramesh
flatfiles is fast then oracle,because in flat files there
is no constraints.
| Is This Answer Correct ? | 3 Yes | 0 No |
why we r using presql&postsql in source qualifier?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
How to display null values on a target & non-null values on a target?
what is the process of target load planing?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
what are the difference between Informatica 7.1 and 8.1?
Label in Informatica. How to remove existing Label.
Quickly characterize reusable change?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?