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 |
What is DR strategy for Informatica project?
Normalizer transformation is not involved in Mapplet.. why???
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
Write the different tools in the workflow manager?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is expression transformation?
Define pmcmd command?
Differentiate between source qualifier and filter transformation?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?